APPS.PAY_TRGL_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 558: pay_element_types_f et

554: pay_costs cst,
555: pay_cost_allocation_keyflex caf,
556: pay_run_results rr,
557: pay_input_values_f IV,
558: pay_element_types_f et
559: WHERE pa.payroll_action_id = :i_payroll_action_id
560: AND pa.assignment_id = per.assignment_id
561: AND per.payroll_id = :c_payroll_id
562: AND pi.locking_action_id = pa.assignment_action_id

Line 621: pay_element_types_f ET1,

617: UNION ALL
618: select RR1.run_result_id
619: FROM pay_run_results RR1,
620: per_all_assignments_f PERA,
621: pay_element_types_f ET1,
622: pay_element_classifications EC,
623: pay_element_links_f EL1
624: WHERE RR1.assignment_action_id = pa2.assignment_action_id
625: AND RR1.run_result_id = nvl(CST.distributed_run_result_id,

Line 762: pay_element_types_f et

758: pay_costs cst,
759: pay_cost_allocation_keyflex caf,
760: pay_run_results rr,
761: pay_input_values_f IV,
762: pay_element_types_f et
763: WHERE pa.payroll_action_id = :i_payroll_action_id
764: AND pa.assignment_id = per.assignment_id
765: AND per.payroll_id = :c_payroll_id
766: AND pi.locking_action_id = pa.assignment_action_id

Line 825: pay_element_types_f ET1,

821: UNION ALL
822: select RR1.run_result_id
823: FROM pay_run_results RR1,
824: per_all_assignments_f PERA,
825: pay_element_types_f ET1,
826: pay_element_classifications EC,
827: pay_element_links_f EL1
828: WHERE RR1.assignment_action_id = pa2.assignment_action_id
829: AND RR1.run_result_id = nvl(CST.distributed_run_result_id,

Line 1648: pay_element_types_f et,

1644: FROM pay_payroll_actions ppa, -- run payroll action
1645: pay_assignment_actions raa,
1646: pay_costs cst,
1647: pay_run_results rr,
1648: pay_element_types_f et,
1649: pay_input_values_f IV
1650: WHERE cst.assignment_action_id = c_assignment_action_id
1651: AND raa.payroll_action_id = r_payroll_action_id
1652: AND raa.assignment_id = r_assignment_id

Line 1714: pay_element_types_f ET1,

1710: UNION ALL
1711: select /*+ ORDERED */
1712: RR1.run_result_id
1713: FROM pay_run_results RR1,
1714: pay_element_types_f ET1,
1715: pay_element_links_f EL1,
1716: per_all_assignments_f PERA
1717: WHERE RR1.assignment_action_id = raa.assignment_action_id
1718: AND RR1.run_result_id = nvl(CST.distributed_run_result_id,

Line 1860: pay_element_types_f et

1856: decode (CST.source_id, null, null, l_accounting_date)
1857: FROM pay_payroll_actions ppa, -- TGL payroll action
1858: pay_costs cst,
1859: pay_input_values_f IV,
1860: pay_element_types_f et
1861: WHERE ppa.payroll_action_id = t_payroll_action_id
1862: AND cst.assignment_action_id = c_assignment_action_id
1863: AND IV.input_value_id = nvl(CST.distributed_input_value_id,
1864: CST.input_value_id)