APPS.PAY_TRGL_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 551: pay_element_types_f et

547: pay_costs cst,
548: pay_cost_allocation_keyflex caf,
549: pay_run_results rr,
550: pay_input_values_f IV,
551: pay_element_types_f et
552: WHERE pa.payroll_action_id = :i_payroll_action_id
553: AND pa.assignment_id = per.assignment_id
554: AND per.payroll_id = :c_payroll_id
555: AND pi.locking_action_id = pa.assignment_action_id

Line 614: pay_element_types_f ET1,

610: UNION ALL
611: select RR1.run_result_id
612: FROM pay_run_results RR1,
613: per_all_assignments_f PERA,
614: pay_element_types_f ET1,
615: pay_element_classifications EC,
616: pay_element_links_f EL1
617: WHERE RR1.assignment_action_id = pa2.assignment_action_id
618: AND RR1.run_result_id = nvl(CST.distributed_run_result_id,

Line 755: pay_element_types_f et

751: pay_costs cst,
752: pay_cost_allocation_keyflex caf,
753: pay_run_results rr,
754: pay_input_values_f IV,
755: pay_element_types_f et
756: WHERE pa.payroll_action_id = :i_payroll_action_id
757: AND pa.assignment_id = per.assignment_id
758: AND per.payroll_id = :c_payroll_id
759: AND pi.locking_action_id = pa.assignment_action_id

Line 818: pay_element_types_f ET1,

814: UNION ALL
815: select RR1.run_result_id
816: FROM pay_run_results RR1,
817: per_all_assignments_f PERA,
818: pay_element_types_f ET1,
819: pay_element_classifications EC,
820: pay_element_links_f EL1
821: WHERE RR1.assignment_action_id = pa2.assignment_action_id
822: AND RR1.run_result_id = nvl(CST.distributed_run_result_id,

Line 1629: pay_element_types_f et,

1625: FROM pay_payroll_actions ppa, -- run payroll action
1626: pay_assignment_actions raa,
1627: pay_costs cst,
1628: pay_run_results rr,
1629: pay_element_types_f et,
1630: pay_input_values_f IV
1631: WHERE cst.assignment_action_id = c_assignment_action_id
1632: AND raa.payroll_action_id = r_payroll_action_id
1633: AND raa.assignment_id = r_assignment_id

Line 1695: pay_element_types_f ET1,

1691: UNION ALL
1692: select /*+ ORDERED */
1693: RR1.run_result_id
1694: FROM pay_run_results RR1,
1695: pay_element_types_f ET1,
1696: pay_element_links_f EL1,
1697: per_all_assignments_f PERA
1698: WHERE RR1.assignment_action_id = raa.assignment_action_id
1699: AND RR1.run_result_id = nvl(CST.distributed_run_result_id,

Line 1841: pay_element_types_f et

1837: decode (CST.source_id, null, null, l_accounting_date)
1838: FROM pay_payroll_actions ppa, -- TGL payroll action
1839: pay_costs cst,
1840: pay_input_values_f IV,
1841: pay_element_types_f et
1842: WHERE ppa.payroll_action_id = t_payroll_action_id
1843: AND cst.assignment_action_id = c_assignment_action_id
1844: AND IV.input_value_id = nvl(CST.distributed_input_value_id,
1845: CST.input_value_id)