APPS.PAY_NL_GENERAL dependencies on PAY_ELEMENT_TYPES_F

Line 500: ,pay_element_types_f pet

496: ,pay_balance_types pbt
497: ,pay_input_values_f piv
498: ,pay_input_values_f piv1
499: ,pay_input_values_f piv2
500: ,pay_element_types_f pet
501: ,pay_run_results prr
502: ,pay_run_result_values prrv
503: ,pay_run_result_values prrv1
504: WHERE pbf.balance_type_id = pbt.balance_type_id

Line 1107: from pay_element_types_f

1103: IS
1104: l_element_type_id number;
1105: BEGIN
1106: select element_type_id into l_element_type_id
1107: from pay_element_types_f
1108: where element_name = p_element_name
1109: and p_effective_date between effective_start_date and effective_end_date
1110: and legislation_code='NL';
1111:

Line 1369: pay_element_types_f pet,

1365: pay_payroll_actions ppa,
1366: pay_assignment_actions paa,
1367: pay_run_results prr,
1368: pay_run_result_values prv,
1369: pay_element_types_f pet,
1370: pay_element_classifications pec,
1371: pay_input_values_f piv
1372: where
1373: paa.payroll_action_id=ppa.payroll_action_id

Line 1414: pay_element_types_f pet,

1410: pay_payroll_actions ppa,
1411: pay_assignment_actions paa,
1412: pay_run_results prr,
1413: pay_run_result_values prv,
1414: pay_element_types_f pet,
1415: pay_element_classifications pec,
1416: pay_sub_classification_rules_f pecs,
1417: pay_input_values_f piv
1418: where

Line 1551: pay_element_types_f pet,

1547: pay_payroll_actions ppa,
1548: pay_assignment_actions paa,
1549: pay_run_results prr,
1550: pay_run_result_values prv,
1551: pay_element_types_f pet,
1552: pay_element_classifications pec,
1553: pay_input_values_f piv
1554: where
1555: paa.payroll_action_id=ppa.payroll_action_id

Line 1706: pay_element_types_f pet,

1702: pay_payroll_actions ppa,
1703: pay_assignment_actions paa,
1704: pay_run_results prr,
1705: pay_run_result_values prv,
1706: pay_element_types_f pet,
1707: pay_element_classifications pec,
1708: pay_sub_classification_rules_f pecs,
1709: pay_input_values_f piv
1710: where

Line 1881: ,pay_element_types_f petf

1877: FROM dual
1878: WHERE exists (SELECT 1
1879: FROM pay_object_groups pog
1880: ,pay_element_entries_f peef
1881: ,pay_element_types_f petf
1882: WHERE pog.parent_object_group_id = c_parent_id
1883: AND peef.assignment_id = pog.source_id
1884: AND peef.element_type_id = petf.element_type_id
1885: AND petf.element_name = 'Late Hire Indicator'

Line 2066: ,pay_element_types_f petf

2062: FROM dual
2063: WHERE exists (SELECT 1
2064: FROM pay_object_groups pog
2065: ,pay_element_entries_f peef
2066: ,pay_element_types_f petf
2067: WHERE pog.parent_object_group_id = c_parent_id
2068: AND peef.assignment_id = pog.source_id
2069: AND peef.element_type_id = petf.element_type_id
2070: AND petf.element_name = 'Late Hire Indicator'

Line 2296: ,pay_element_types_f petf

2292: SELECT 'Y'
2293: FROM dual
2294: WHERE exists (SELECT 1
2295: FROM pay_element_entries_f peef
2296: ,pay_element_types_f petf
2297: WHERE peef.assignment_id = c_ass_id
2298: AND peef.element_type_id = petf.element_type_id
2299: AND petf.element_name = 'Late Hire Indicator'
2300: AND c_eff_date BETWEEN peef.effective_start_date AND peef.effective_end_date

Line 2534: ,pay_element_types_f petf

2530: SELECT 'Y'
2531: FROM dual
2532: WHERE exists (SELECT 1
2533: FROM pay_element_entries_f peef
2534: ,pay_element_types_f petf
2535: WHERE peef.assignment_id = c_ass_id
2536: AND peef.element_type_id = petf.element_type_id
2537: AND petf.element_name = 'Late Hire Indicator'
2538: AND c_eff_date BETWEEN peef.effective_start_date AND peef.effective_end_date