APPS.PAY_AC_ACTION_ARCH dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 374: pay_element_classifications pec,

370: from pay_assignment_actions paa,
371: pay_payroll_actions ppa,
372: pay_run_results prr,
373: pay_element_types_f pet,
374: pay_element_classifications pec,
375: pay_element_types_f_tl petl
376: where prr.assignment_action_id = paa.assignment_action_id
377: and paa.assignment_id = cp_assignment_id
378: and ppa.payroll_action_id = paa.payroll_action_id

Line 447: ,pay_element_classifications pec

443: from pay_run_balances prb
444: ,pay_defined_balances pdb
445: ,pay_balance_types pbt
446: ,pay_element_types_f pet
447: ,pay_element_classifications pec
448: ,pay_element_types_f_tl petl
449: where prb.effective_date >= cp_start_eff_date
450: and prb.effective_date <= cp_curr_eff_date
451: and prb.assignment_id = cp_assignment_id

Line 1314: pay_element_classifications pec

1310: select pec.classification_name,
1311: pet.element_information10 primary_balance_id,
1312: pet.element_information12 hours_balance_id
1313: from pay_element_types_f pet,
1314: pay_element_classifications pec
1315: where pet.element_type_id = cp_element_type_id
1316: and p_curr_pymt_eff_date between pet.effective_start_date
1317: and pet.effective_end_date
1318: and pec.classification_id = pet.classification_id;

Line 1829: pay_element_classifications ec,

1825: from pay_assignment_actions paa,
1826: pay_payroll_actions ppa,
1827: per_time_periods ptp,
1828: pay_element_entries_f peef,
1829: pay_element_classifications ec,
1830: pay_element_types et
1831: where paa.assignment_action_id = cp_run_assignment_action_id
1832: and paa.payroll_action_id = ppa.payroll_action_id
1833: and ptp.payroll_id = ppa.payroll_id

Line 1910: pay_element_classifications pec,

1906: from pay_assignment_actions paa,
1907: pay_payroll_actions ppa,
1908: pay_run_results prr,
1909: pay_element_types_f pet,
1910: pay_element_classifications pec,
1911: pay_element_types_f_tl petl
1912: where paa.assignment_id = cp_assignment_id
1913: and prr.assignment_action_id = paa.assignment_action_id
1914: and cp_sepchk_flag = 'Y'

Line 1961: pay_element_classifications pec,

1957: pay_payroll_actions ppa,
1958: pay_all_payrolls_f ppf,
1959: pay_run_results prr,
1960: pay_element_types_f pet,
1961: pay_element_classifications pec,
1962: pay_element_types_f_tl petl
1963: where paa.assignment_id = cp_assignment_id
1964: and prr.assignment_action_id = paa.assignment_action_id
1965: and cp_sepchk_flag = 'N'

Line 2938: PAY_ELEMENT_CLASSIFICATIONS PEC,

2934: PAY_PAYROLL_ACTIONS PPA,
2935: PAY_PAYROLLS_F PPF,
2936: PAY_RUN_RESULTS PRR,
2937: PAY_ELEMENT_TYPES_F PET ,
2938: PAY_ELEMENT_CLASSIFICATIONS PEC,
2939: PAY_ELEMENT_TYPES_F_TL PETL
2940: /*changing the order for bug 5549032
2941: pay_run_results prr,
2942: pay_element_types_f pet ,

Line 2943: pay_element_classifications pec,

2939: PAY_ELEMENT_TYPES_F_TL PETL
2940: /*changing the order for bug 5549032
2941: pay_run_results prr,
2942: pay_element_types_f pet ,
2943: pay_element_classifications pec,
2944: pay_assignment_actions paa,
2945: pay_payroll_actions ppa,
2946: pay_element_types_f_tl petl,
2947: pay_all_payrolls_f ppf */ -- Bug 3370112

Line 4278: pay_element_classifications ec

4274: per_time_periods ptp,
4275: pay_payroll_actions ppa,
4276: pay_assignment_actions paa,
4277: pay_element_types_f et,
4278: pay_element_classifications ec
4279: where peef.element_entry_id = cp_element_entry_id
4280: AND peef.creator_type IN ('EE', 'NR', 'PR', 'R', 'RR')
4281: AND et.element_type_id = peef.element_type_id
4282: AND et.classification_id = ec.classification_id

Line 4772: pay_element_classifications ec,

4768: from pay_assignment_actions paa,
4769: pay_payroll_actions ppa,
4770: per_time_periods ptp,
4771: pay_element_entries_f peef,
4772: pay_element_classifications ec,
4773: pay_element_types et
4774: where paa.assignment_action_id = cp_run_assignment_action_id
4775: and paa.payroll_action_id = ppa.payroll_action_id
4776: and ptp.payroll_id = ppa.payroll_id