Scribd
Upload
1K views10 pages

Calculation Card

The document contains an SQL query that selects data from multiple tables, joining them together based on foreign key relationships between the tables. The query filters and returns data from the pay_range_items_f table based on joins to other tables containing reference data.

Uploaded by

Rajanikant Tagarrati Venkata
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
1K views10 pages

Calculation Card

The document contains an SQL query that selects data from multiple tables, joining them together based on foreign key relationships between the tables. The query filters and returns data from the pay_range_items_f table based on joins to other tables containing reference data.

Uploaded by

Rajanikant Tagarrati Venkata
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 10

SELECT

pri.*
FROM
fusion.pay_range_items_f pri,
fusion.pay_value_definitions_f vd,
fusion.pay_dir_override_usages_f dou,
fusion.pay_allow_overrides_vl aor,
fusion.pay_value_definitions_vl vdl,
pay_dir_card_components_f pdcc,
pay_dir_card_definitions_vl pdcd,
pay_dir_card_comp_defs_vl pdccd,
pay_dir_cards_f pdcf,
pay_element_entries_f pee
WHERE
pri.value_defn_id = vd.value_defn_id
AND vd.dir_override_usage_id = dou.dir_override_usage_id
AND dou.allow_overrides_id = aor.allow_overrides_id
AND vd.parent_value_defn_id = vdl.value_defn_id
-- AND vdl.base_name = 'Time Unit'
-- AND vd.source_type = 'PDCC'
AND vd.source_id = pdcc.dir_card_comp_id
AND pdccd.dir_card_comp_def_id = pdcc.dir_card_comp_def_id
AND pdccd.dir_card_definition_id = pdcd.dir_card_definition_id
-- AND pdcd.base_display_name = 'Time Cards'
AND pdcc.dir_card_id = pdcf.dir_card_id
AND pee.element_type_id = pdccd.element_type_id
AND pee.creator_id = pdcc.dir_card_comp_id
AND pee.creator_type = 'DIR_COMP'SELECT
pri.*
FROM
fusion.pay_range_items_f pri,
fusion.pay_value_definitions_f vd,
fusion.pay_dir_override_usages_f dou,
fusion.pay_allow_overrides_vl aor,
fusion.pay_value_definitions_vl vdl,
pay_dir_card_components_f pdcc,
pay_dir_card_definitions_vl pdcd,
pay_dir_card_comp_defs_vl pdccd,
pay_dir_cards_f pdcf,
pay_element_entries_f pee
WHERE
pri.value_defn_id = vd.value_defn_id
AND vd.dir_override_usage_id = dou.dir_override_usage_id
AND dou.allow_overrides_id = aor.allow_overrides_id
AND vd.parent_value_defn_id = vdl.value_defn_id
-- AND vdl.base_name = 'Time Unit'
-- AND vd.source_type = 'PDCC'
AND vd.source_id = pdcc.dir_card_comp_id
AND pdccd.dir_card_comp_def_id = pdcc.dir_card_comp_def_id
AND pdccd.dir_card_definition_id = pdcd.dir_card_definition_id
-- AND pdcd.base_display_name = 'Time Cards'
AND pdcc.dir_card_id = pdcf.dir_card_id
AND pee.element_type_id = pdccd.element_type_id
AND pee.creator_id = pdcc.dir_card_comp_id
AND pee.creator_type = 'DIR_COMP'SELECT
pri.*
FROM
fusion.pay_range_items_f pri,
fusion.pay_value_definitions_f vd,
fusion.pay_dir_override_usages_f dou,
fusion.pay_allow_overrides_vl aor,
fusion.pay_value_definitions_vl vdl,
pay_dir_card_components_f pdcc,
pay_dir_card_definitions_vl pdcd,
pay_dir_card_comp_defs_vl pdccd,
pay_dir_cards_f pdcf,
pay_element_entries_f pee
WHERE
pri.value_defn_id = vd.value_defn_id
AND vd.dir_override_usage_id = dou.dir_override_usage_id
AND dou.allow_overrides_id = aor.allow_overrides_id
AND vd.parent_value_defn_id = vdl.value_defn_id
-- AND vdl.base_name = 'Time Unit'
-- AND vd.source_type = 'PDCC'
AND vd.source_id = pdcc.dir_card_comp_id
AND pdccd.dir_card_comp_def_id = pdcc.dir_card_comp_def_id
AND pdccd.dir_card_definition_id = pdcd.dir_card_definition_id
-- AND pdcd.base_display_name = 'Time Cards'
AND pdcc.dir_card_id = pdcf.dir_card_id
AND pee.element_type_id = pdccd.element_type_id
AND pee.creator_id = pdcc.dir_card_comp_id
AND pee.creator_type = 'DIR_COMP'SELECT
pri.*
FROM
fusion.pay_range_items_f pri,
fusion.pay_value_definitions_f vd,
fusion.pay_dir_override_usages_f dou,
fusion.pay_allow_overrides_vl aor,
fusion.pay_value_definitions_vl vdl,
pay_dir_card_components_f pdcc,
pay_dir_card_definitions_vl pdcd,
pay_dir_card_comp_defs_vl pdccd,
pay_dir_cards_f pdcf,
pay_element_entries_f pee
WHERE
pri.value_defn_id = vd.value_defn_id
AND vd.dir_override_usage_id = dou.dir_override_usage_id
AND dou.allow_overrides_id = aor.allow_overrides_id
AND vd.parent_value_defn_id = vdl.value_defn_id
-- AND vdl.base_name = 'Time Unit'
-- AND vd.source_type = 'PDCC'
AND vd.source_id = pdcc.dir_card_comp_id
AND pdccd.dir_card_comp_def_id = pdcc.dir_card_comp_def_id
AND pdccd.dir_card_definition_id = pdcd.dir_card_definition_id
-- AND pdcd.base_display_name = 'Time Cards'
AND pdcc.dir_card_id = pdcf.dir_card_id
AND pee.element_type_id = pdccd.element_type_id
AND pee.creator_id = pdcc.dir_card_comp_id
AND pee.creator_type = 'DIR_COMP'SELECT
pri.*
FROM
fusion.pay_range_items_f pri,
fusion.pay_value_definitions_f vd,
fusion.pay_dir_override_usages_f dou,
fusion.pay_allow_overrides_vl aor,
fusion.pay_value_definitions_vl vdl,
pay_dir_card_components_f pdcc,
pay_dir_card_definitions_vl pdcd,
pay_dir_card_comp_defs_vl pdccd,
pay_dir_cards_f pdcf,
pay_element_entries_f pee
WHERE
pri.value_defn_id = vd.value_defn_id
AND vd.dir_override_usage_id = dou.dir_override_usage_id
AND dou.allow_overrides_id = aor.allow_overrides_id
AND vd.parent_value_defn_id = vdl.value_defn_id
-- AND vdl.base_name = 'Time Unit'
-- AND vd.source_type = 'PDCC'
AND vd.source_id = pdcc.dir_card_comp_id
AND pdccd.dir_card_comp_def_id = pdcc.dir_card_comp_def_id
AND pdccd.dir_card_definition_id = pdcd.dir_card_definition_id
-- AND pdcd.base_display_name = 'Time Cards'
AND pdcc.dir_card_id = pdcf.dir_card_id
AND pee.element_type_id = pdccd.element_type_id
AND pee.creator_id = pdcc.dir_card_comp_id
AND pee.creator_type = 'DIR_COMP'SELECT
pri.*
FROM
fusion.pay_range_items_f pri,
fusion.pay_value_definitions_f vd,
fusion.pay_dir_override_usages_f dou,
fusion.pay_allow_overrides_vl aor,
fusion.pay_value_definitions_vl vdl,
pay_dir_card_components_f pdcc,
pay_dir_card_definitions_vl pdcd,
pay_dir_card_comp_defs_vl pdccd,
pay_dir_cards_f pdcf,
pay_element_entries_f pee
WHERE
pri.value_defn_id = vd.value_defn_id
AND vd.dir_override_usage_id = dou.dir_override_usage_id
AND dou.allow_overrides_id = aor.allow_overrides_id
AND vd.parent_value_defn_id = vdl.value_defn_id
-- AND vdl.base_name = 'Time Unit'
-- AND vd.source_type = 'PDCC'
AND vd.source_id = pdcc.dir_card_comp_id
AND pdccd.dir_card_comp_def_id = pdcc.dir_card_comp_def_id
AND pdccd.dir_card_definition_id = pdcd.dir_card_definition_id
-- AND pdcd.base_display_name = 'Time Cards'
AND pdcc.dir_card_id = pdcf.dir_card_id
AND pee.element_type_id = pdccd.element_type_id
AND pee.creator_id = pdcc.dir_card_comp_id
AND pee.creator_type = 'DIR_COMP'SELECT
pri.*
FROM
fusion.pay_range_items_f pri,
fusion.pay_value_definitions_f vd,
fusion.pay_dir_override_usages_f dou,
fusion.pay_allow_overrides_vl aor,
fusion.pay_value_definitions_vl vdl,
pay_dir_card_components_f pdcc,
pay_dir_card_definitions_vl pdcd,
pay_dir_card_comp_defs_vl pdccd,
pay_dir_cards_f pdcf,
pay_element_entries_f pee
WHERE
pri.value_defn_id = vd.value_defn_id
AND vd.dir_override_usage_id = dou.dir_override_usage_id
AND dou.allow_overrides_id = aor.allow_overrides_id
AND vd.parent_value_defn_id = vdl.value_defn_id
-- AND vdl.base_name = 'Time Unit'
-- AND vd.source_type = 'PDCC'
AND vd.source_id = pdcc.dir_card_comp_id
AND pdccd.dir_card_comp_def_id = pdcc.dir_card_comp_def_id
AND pdccd.dir_card_definition_id = pdcd.dir_card_definition_id
-- AND pdcd.base_display_name = 'Time Cards'
AND pdcc.dir_card_id = pdcf.dir_card_id
AND pee.element_type_id = pdccd.element_type_id
AND pee.creator_id = pdcc.dir_card_comp_id
AND pee.creator_type = 'DIR_COMP'SELECT
pri.*
FROM
fusion.pay_range_items_f pri,
fusion.pay_value_definitions_f vd,
fusion.pay_dir_override_usages_f dou,
fusion.pay_allow_overrides_vl aor,
fusion.pay_value_definitions_vl vdl,
pay_dir_card_components_f pdcc,
pay_dir_card_definitions_vl pdcd,
pay_dir_card_comp_defs_vl pdccd,
pay_dir_cards_f pdcf,
pay_element_entries_f pee
WHERE
pri.value_defn_id = vd.value_defn_id
AND vd.dir_override_usage_id = dou.dir_override_usage_id
AND dou.allow_overrides_id = aor.allow_overrides_id
AND vd.parent_value_defn_id = vdl.value_defn_id
-- AND vdl.base_name = 'Time Unit'
-- AND vd.source_type = 'PDCC'
AND vd.source_id = pdcc.dir_card_comp_id
AND pdccd.dir_card_comp_def_id = pdcc.dir_card_comp_def_id
AND pdccd.dir_card_definition_id = pdcd.dir_card_definition_id
-- AND pdcd.base_display_name = 'Time Cards'
AND pdcc.dir_card_id = pdcf.dir_card_id
AND pee.element_type_id = pdccd.element_type_id
AND pee.creator_id = pdcc.dir_card_comp_id
AND pee.creator_type = 'DIR_COMP'SELECT
pri.*
FROM
fusion.pay_range_items_f pri,
fusion.pay_value_definitions_f vd,
fusion.pay_dir_override_usages_f dou,
fusion.pay_allow_overrides_vl aor,
fusion.pay_value_definitions_vl vdl,
pay_dir_card_components_f pdcc,
pay_dir_card_definitions_vl pdcd,
pay_dir_card_comp_defs_vl pdccd,
pay_dir_cards_f pdcf,
pay_element_entries_f pee
WHERE
pri.value_defn_id = vd.value_defn_id
AND vd.dir_override_usage_id = dou.dir_override_usage_id
AND dou.allow_overrides_id = aor.allow_overrides_id
AND vd.parent_value_defn_id = vdl.value_defn_id
-- AND vdl.base_name = 'Time Unit'
-- AND vd.source_type = 'PDCC'
AND vd.source_id = pdcc.dir_card_comp_id
AND pdccd.dir_card_comp_def_id = pdcc.dir_card_comp_def_id
AND pdccd.dir_card_definition_id = pdcd.dir_card_definition_id
-- AND pdcd.base_display_name = 'Time Cards'
AND pdcc.dir_card_id = pdcf.dir_card_id
AND pee.element_type_id = pdccd.element_type_id
AND pee.creator_id = pdcc.dir_card_comp_id
AND pee.creator_type = 'DIR_COMP'SELECT
pri.*
FROM
fusion.pay_range_items_f pri,
fusion.pay_value_definitions_f vd,
fusion.pay_dir_override_usages_f dou,
fusion.pay_allow_overrides_vl aor,
fusion.pay_value_definitions_vl vdl,
pay_dir_card_components_f pdcc,
pay_dir_card_definitions_vl pdcd,
pay_dir_card_comp_defs_vl pdccd,
pay_dir_cards_f pdcf,
pay_element_entries_f pee
WHERE
pri.value_defn_id = vd.value_defn_id
AND vd.dir_override_usage_id = dou.dir_override_usage_id
AND dou.allow_overrides_id = aor.allow_overrides_id
AND vd.parent_value_defn_id = vdl.value_defn_id
-- AND vdl.base_name = 'Time Unit'
-- AND vd.source_type = 'PDCC'
AND vd.source_id = pdcc.dir_card_comp_id
AND pdccd.dir_card_comp_def_id = pdcc.dir_card_comp_def_id
AND pdccd.dir_card_definition_id = pdcd.dir_card_definition_id
-- AND pdcd.base_display_name = 'Time Cards'
AND pdcc.dir_card_id = pdcf.dir_card_id
AND pee.element_type_id = pdccd.element_type_id
AND pee.creator_id = pdcc.dir_card_comp_id
AND pee.creator_type = 'DIR_COMP'SELECT
pri.*
FROM
fusion.pay_range_items_f pri,
fusion.pay_value_definitions_f vd,
fusion.pay_dir_override_usages_f dou,
fusion.pay_allow_overrides_vl aor,
fusion.pay_value_definitions_vl vdl,
pay_dir_card_components_f pdcc,
pay_dir_card_definitions_vl pdcd,
pay_dir_card_comp_defs_vl pdccd,
pay_dir_cards_f pdcf,
pay_element_entries_f pee
WHERE
pri.value_defn_id = vd.value_defn_id
AND vd.dir_override_usage_id = dou.dir_override_usage_id
AND dou.allow_overrides_id = aor.allow_overrides_id
AND vd.parent_value_defn_id = vdl.value_defn_id
-- AND vdl.base_name = 'Time Unit'
-- AND vd.source_type = 'PDCC'
AND vd.source_id = pdcc.dir_card_comp_id
AND pdccd.dir_card_comp_def_id = pdcc.dir_card_comp_def_id
AND pdccd.dir_card_definition_id = pdcd.dir_card_definition_id
-- AND pdcd.base_display_name = 'Time Cards'
AND pdcc.dir_card_id = pdcf.dir_card_id
AND pee.element_type_id = pdccd.element_type_id
AND pee.creator_id = pdcc.dir_card_comp_id
AND pee.creator_type = 'DIR_COMP'SELECT
pri.*
FROM
fusion.pay_range_items_f pri,
fusion.pay_value_definitions_f vd,
fusion.pay_dir_override_usages_f dou,
fusion.pay_allow_overrides_vl aor,
fusion.pay_value_definitions_vl vdl,
pay_dir_card_components_f pdcc,
pay_dir_card_definitions_vl pdcd,
pay_dir_card_comp_defs_vl pdccd,
pay_dir_cards_f pdcf,
pay_element_entries_f pee
WHERE
pri.value_defn_id = vd.value_defn_id
AND vd.dir_override_usage_id = dou.dir_override_usage_id
AND dou.allow_overrides_id = aor.allow_overrides_id
AND vd.parent_value_defn_id = vdl.value_defn_id
-- AND vdl.base_name = 'Time Unit'
-- AND vd.source_type = 'PDCC'
AND vd.source_id = pdcc.dir_card_comp_id
AND pdccd.dir_card_comp_def_id = pdcc.dir_card_comp_def_id
AND pdccd.dir_card_definition_id = pdcd.dir_card_definition_id
-- AND pdcd.base_display_name = 'Time Cards'
AND pdcc.dir_card_id = pdcf.dir_card_id
AND pee.element_type_id = pdccd.element_type_id
AND pee.creator_id = pdcc.dir_card_comp_id
AND pee.creator_type = 'DIR_COMP'SELECT
pri.*
FROM
fusion.pay_range_items_f pri,
fusion.pay_value_definitions_f vd,
fusion.pay_dir_override_usages_f dou,
fusion.pay_allow_overrides_vl aor,
fusion.pay_value_definitions_vl vdl,
pay_dir_card_components_f pdcc,
pay_dir_card_definitions_vl pdcd,
pay_dir_card_comp_defs_vl pdccd,
pay_dir_cards_f pdcf,
pay_element_entries_f pee
WHERE
pri.value_defn_id = vd.value_defn_id
AND vd.dir_override_usage_id = dou.dir_override_usage_id
AND dou.allow_overrides_id = aor.allow_overrides_id
AND vd.parent_value_defn_id = vdl.value_defn_id
-- AND vdl.base_name = 'Time Unit'
-- AND vd.source_type = 'PDCC'
AND vd.source_id = pdcc.dir_card_comp_id
AND pdccd.dir_card_comp_def_id = pdcc.dir_card_comp_def_id
AND pdccd.dir_card_definition_id = pdcd.dir_card_definition_id
-- AND pdcd.base_display_name = 'Time Cards'
AND pdcc.dir_card_id = pdcf.dir_card_id
AND pee.element_type_id = pdccd.element_type_id
AND pee.creator_id = pdcc.dir_card_comp_id
AND pee.creator_type = 'DIR_COMP'SELECT
pri.*
FROM
fusion.pay_range_items_f pri,
fusion.pay_value_definitions_f vd,
fusion.pay_dir_override_usages_f dou,
fusion.pay_allow_overrides_vl aor,
fusion.pay_value_definitions_vl vdl,
pay_dir_card_components_f pdcc,
pay_dir_card_definitions_vl pdcd,
pay_dir_card_comp_defs_vl pdccd,
pay_dir_cards_f pdcf,
pay_element_entries_f pee
WHERE
pri.value_defn_id = vd.value_defn_id
AND vd.dir_override_usage_id = dou.dir_override_usage_id
AND dou.allow_overrides_id = aor.allow_overrides_id
AND vd.parent_value_defn_id = vdl.value_defn_id
-- AND vdl.base_name = 'Time Unit'
-- AND vd.source_type = 'PDCC'
AND vd.source_id = pdcc.dir_card_comp_id
AND pdccd.dir_card_comp_def_id = pdcc.dir_card_comp_def_id
AND pdccd.dir_card_definition_id = pdcd.dir_card_definition_id
-- AND pdcd.base_display_name = 'Time Cards'
AND pdcc.dir_card_id = pdcf.dir_card_id
AND pee.element_type_id = pdccd.element_type_id
AND pee.creator_id = pdcc.dir_card_comp_id
AND pee.creator_type = 'DIR_COMP'SELECT
pri.*
FROM
fusion.pay_range_items_f pri,
fusion.pay_value_definitions_f vd,
fusion.pay_dir_override_usages_f dou,
fusion.pay_allow_overrides_vl aor,
fusion.pay_value_definitions_vl vdl,
pay_dir_card_components_f pdcc,
pay_dir_card_definitions_vl pdcd,
pay_dir_card_comp_defs_vl pdccd,
pay_dir_cards_f pdcf,
pay_element_entries_f pee
WHERE
pri.value_defn_id = vd.value_defn_id
AND vd.dir_override_usage_id = dou.dir_override_usage_id
AND dou.allow_overrides_id = aor.allow_overrides_id
AND vd.parent_value_defn_id = vdl.value_defn_id
-- AND vdl.base_name = 'Time Unit'
-- AND vd.source_type = 'PDCC'
AND vd.source_id = pdcc.dir_card_comp_id
AND pdccd.dir_card_comp_def_id = pdcc.dir_card_comp_def_id
AND pdccd.dir_card_definition_id = pdcd.dir_card_definition_id
-- AND pdcd.base_display_name = 'Time Cards'
AND pdcc.dir_card_id = pdcf.dir_card_id
AND pee.element_type_id = pdccd.element_type_id
AND pee.creator_id = pdcc.dir_card_comp_id
AND pee.creator_type = 'DIR_COMP'SELECT
pri.*
FROM
fusion.pay_range_items_f pri,
fusion.pay_value_definitions_f vd,
fusion.pay_dir_override_usages_f dou,
fusion.pay_allow_overrides_vl aor,
fusion.pay_value_definitions_vl vdl,
pay_dir_card_components_f pdcc,
pay_dir_card_definitions_vl pdcd,
pay_dir_card_comp_defs_vl pdccd,
pay_dir_cards_f pdcf,
pay_element_entries_f pee
WHERE
pri.value_defn_id = vd.value_defn_id
AND vd.dir_override_usage_id = dou.dir_override_usage_id
AND dou.allow_overrides_id = aor.allow_overrides_id
AND vd.parent_value_defn_id = vdl.value_defn_id
-- AND vdl.base_name = 'Time Unit'
-- AND vd.source_type = 'PDCC'
AND vd.source_id = pdcc.dir_card_comp_id
AND pdccd.dir_card_comp_def_id = pdcc.dir_card_comp_def_id
AND pdccd.dir_card_definition_id = pdcd.dir_card_definition_id
-- AND pdcd.base_display_name = 'Time Cards'
AND pdcc.dir_card_id = pdcf.dir_card_id
AND pee.element_type_id = pdccd.element_type_id
AND pee.creator_id = pdcc.dir_card_comp_id
AND pee.creator_type = 'DIR_COMP'SELECT
pri.*
FROM
fusion.pay_range_items_f pri,
fusion.pay_value_definitions_f vd,
fusion.pay_dir_override_usages_f dou,
fusion.pay_allow_overrides_vl aor,
fusion.pay_value_definitions_vl vdl,
pay_dir_card_components_f pdcc,
pay_dir_card_definitions_vl pdcd,
pay_dir_card_comp_defs_vl pdccd,
pay_dir_cards_f pdcf,
pay_element_entries_f pee
WHERE
pri.value_defn_id = vd.value_defn_id
AND vd.dir_override_usage_id = dou.dir_override_usage_id
AND dou.allow_overrides_id = aor.allow_overrides_id
AND vd.parent_value_defn_id = vdl.value_defn_id
-- AND vdl.base_name = 'Time Unit'
-- AND vd.source_type = 'PDCC'
AND vd.source_id = pdcc.dir_card_comp_id
AND pdccd.dir_card_comp_def_id = pdcc.dir_card_comp_def_id
AND pdccd.dir_card_definition_id = pdcd.dir_card_definition_id
-- AND pdcd.base_display_name = 'Time Cards'
AND pdcc.dir_card_id = pdcf.dir_card_id
AND pee.element_type_id = pdccd.element_type_id
AND pee.creator_id = pdcc.dir_card_comp_id
AND pee.creator_type = 'DIR_COMP'SELECT
pri.*
FROM
fusion.pay_range_items_f pri,
fusion.pay_value_definitions_f vd,
fusion.pay_dir_override_usages_f dou,
fusion.pay_allow_overrides_vl aor,
fusion.pay_value_definitions_vl vdl,
pay_dir_card_components_f pdcc,
pay_dir_card_definitions_vl pdcd,
pay_dir_card_comp_defs_vl pdccd,
pay_dir_cards_f pdcf,
pay_element_entries_f pee
WHERE
pri.value_defn_id = vd.value_defn_id
AND vd.dir_override_usage_id = dou.dir_override_usage_id
AND dou.allow_overrides_id = aor.allow_overrides_id
AND vd.parent_value_defn_id = vdl.value_defn_id
-- AND vdl.base_name = 'Time Unit'
-- AND vd.source_type = 'PDCC'
AND vd.source_id = pdcc.dir_card_comp_id
AND pdccd.dir_card_comp_def_id = pdcc.dir_card_comp_def_id
AND pdccd.dir_card_definition_id = pdcd.dir_card_definition_id
-- AND pdcd.base_display_name = 'Time Cards'
AND pdcc.dir_card_id = pdcf.dir_card_id
AND pee.element_type_id = pdccd.element_type_id
AND pee.creator_id = pdcc.dir_card_comp_id
AND pee.creator_type = 'DIR_COMP'SELECT
pri.*
FROM
fusion.pay_range_items_f pri,
fusion.pay_value_definitions_f vd,
fusion.pay_dir_override_usages_f dou,
fusion.pay_allow_overrides_vl aor,
fusion.pay_value_definitions_vl vdl,
pay_dir_card_components_f pdcc,
pay_dir_card_definitions_vl pdcd,
pay_dir_card_comp_defs_vl pdccd,
pay_dir_cards_f pdcf,
pay_element_entries_f pee
WHERE
pri.value_defn_id = vd.value_defn_id
AND vd.dir_override_usage_id = dou.dir_override_usage_id
AND dou.allow_overrides_id = aor.allow_overrides_id
AND vd.parent_value_defn_id = vdl.value_defn_id
-- AND vdl.base_name = 'Time Unit'
-- AND vd.source_type = 'PDCC'
AND vd.source_id = pdcc.dir_card_comp_id
AND pdccd.dir_card_comp_def_id = pdcc.dir_card_comp_def_id
AND pdccd.dir_card_definition_id = pdcd.dir_card_definition_id
-- AND pdcd.base_display_name = 'Time Cards'
AND pdcc.dir_card_id = pdcf.dir_card_id
AND pee.element_type_id = pdccd.element_type_id
AND pee.creator_id = pdcc.dir_card_comp_id
AND pee.creator_type = 'DIR_COMP'SELECT
pri.*
FROM
fusion.pay_range_items_f pri,
fusion.pay_value_definitions_f vd,
fusion.pay_dir_override_usages_f dou,
fusion.pay_allow_overrides_vl aor,
fusion.pay_value_definitions_vl vdl,
pay_dir_card_components_f pdcc,
pay_dir_card_definitions_vl pdcd,
pay_dir_card_comp_defs_vl pdccd,
pay_dir_cards_f pdcf,
pay_element_entries_f pee
WHERE
pri.value_defn_id = vd.value_defn_id
AND vd.dir_override_usage_id = dou.dir_override_usage_id
AND dou.allow_overrides_id = aor.allow_overrides_id
AND vd.parent_value_defn_id = vdl.value_defn_id
-- AND vdl.base_name = 'Time Unit'
-- AND vd.source_type = 'PDCC'
AND vd.source_id = pdcc.dir_card_comp_id
AND pdccd.dir_card_comp_def_id = pdcc.dir_card_comp_def_id
AND pdccd.dir_card_definition_id = pdcd.dir_card_definition_id
-- AND pdcd.base_display_name = 'Time Cards'
AND pdcc.dir_card_id = pdcf.dir_card_id
AND pee.element_type_id = pdccd.element_type_id
AND pee.creator_id = pdcc.dir_card_comp_id
AND pee.creator_type = 'DIR_COMP'

You might also like