eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_TRGL_PKG dependencies on PAY_RUN_RESULTS

Line 156: 40.7 alogue 19-JUN-1997 Catered for pay_run_results source_id

152: 40.8 alogue 25-JUN-1997 Bug 486556 prod-14 backport. Add
153: pay_basis_id and employment_category to
154: link qualification in element deleted part
155: of 'INSERT INTO gl_interface' cursor.
156: 40.7 alogue 19-JUN-1997 Catered for pay_run_results source_id
157: is reversed run_result_id in case of
158: a reversal. (Result of bug 507602 fix.)
159: 40.6 jalloun 30-JUL-1996 Added error handling.
160: 40.5 nbristow 19-JUL-1996 Bug 368244. The costing process, thus

Line 190: element link table from pay_run_results is very similar to the SQL for the

186: held on the table pay_element_links_f. In release 9 this flag used to be
187: copied down to the costing table. However, this creates problems if the
188: user subsequently goes back and modifies the flag. So, for release 10,
189: it is only held on the link table. The SQL needed to track back to the
190: element link table from pay_run_results is very similar to the SQL for the
191: costing process (file pycos.lpc). The SQL consists of a union, with one
192: half reaching the element link table via the element entry table. The
193: other half is needed for when the element entry has been deleted following
194: a run. In this case the element link table is reached via the element

Line 549: pay_run_results rr,

545: pay_assignment_actions pa3, -- run master assignment action
546: pay_assignment_actions pa2, -- run assignment action
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

Line 576: from pay_run_results RR1

572: and ppa.date_earned between IV.effective_start_date
573: and IV.effective_end_date
574: AND EXISTS
575: (select RR1.run_result_id
576: from pay_run_results RR1
577: , pay_run_results RR2
578: , pay_element_entries_f EE1
579: , pay_element_links_f EL1
580: where RR1.assignment_action_id = pa2.assignment_action_id

Line 577: , pay_run_results RR2

573: and IV.effective_end_date
574: AND EXISTS
575: (select RR1.run_result_id
576: from pay_run_results RR1
577: , pay_run_results RR2
578: , pay_element_entries_f EE1
579: , pay_element_links_f EL1
580: where RR1.assignment_action_id = pa2.assignment_action_id
581: and RR1.source_id = RR2.run_result_id

Line 595: from pay_run_results RR1

591: and RR1.run_result_id = nvl(CST.distributed_run_result_id,
592: CST.run_result_id)
593: UNION ALL
594: select RR1.run_result_id
595: from pay_run_results RR1
596: , pay_element_entries_f EE1
597: , pay_element_links_f EL1
598: where RR1.assignment_action_id = pa2.assignment_action_id
599: and RR1.source_id = EE1.element_entry_id

Line 612: FROM pay_run_results RR1,

608: and RR1.run_result_id = nvl(CST.distributed_run_result_id,
609: CST.run_result_id)
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

Line 632: FROM pay_run_results RR2,

628: AND EE1.effective_end_date
629: )
630: AND NOT EXISTS
631: (SELECT null
632: FROM pay_run_results RR2,
633: pay_element_entries_f EE1
634: WHERE RR2.source_id = EE1.element_entry_id
635: AND RR1.source_type IN (''R'', ''V'')
636: AND RR1.source_id = RR2.run_result_id

Line 753: pay_run_results rr,

749: pay_assignment_actions pa3, -- run master assignment action
750: pay_assignment_actions pa2, -- run assignment action
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

Line 780: from pay_run_results RR1

776: and ppa.date_earned between IV.effective_start_date
777: and IV.effective_end_date
778: AND EXISTS
779: (select RR1.run_result_id
780: from pay_run_results RR1
781: , pay_run_results RR2
782: , pay_element_entries_f EE1
783: , pay_element_links_f EL1
784: where RR1.assignment_action_id = pa2.assignment_action_id

Line 781: , pay_run_results RR2

777: and IV.effective_end_date
778: AND EXISTS
779: (select RR1.run_result_id
780: from pay_run_results RR1
781: , pay_run_results RR2
782: , pay_element_entries_f EE1
783: , pay_element_links_f EL1
784: where RR1.assignment_action_id = pa2.assignment_action_id
785: and RR1.source_id = RR2.run_result_id

Line 799: from pay_run_results RR1

795: and RR1.run_result_id = nvl(CST.distributed_run_result_id,
796: CST.run_result_id)
797: UNION ALL
798: select RR1.run_result_id
799: from pay_run_results RR1
800: , pay_element_entries_f EE1
801: , pay_element_links_f EL1
802: where RR1.assignment_action_id = pa2.assignment_action_id
803: and RR1.source_id = EE1.element_entry_id

Line 816: FROM pay_run_results RR1,

812: and RR1.run_result_id = nvl(CST.distributed_run_result_id,
813: CST.run_result_id)
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

Line 836: FROM pay_run_results RR2,

832: AND EE1.effective_end_date
833: )
834: AND NOT EXISTS
835: (SELECT null
836: FROM pay_run_results RR2,
837: pay_element_entries_f EE1
838: WHERE RR2.source_id = EE1.element_entry_id
839: AND RR1.source_type IN (''R'', ''V'')
840: AND RR1.source_id = RR2.run_result_id

Line 1628: pay_run_results rr,

1624: SUM(DECODE(cst.debit_or_credit,'C',cst.costed_value,0))
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

Line 1654: from pay_run_results RR1

1650: OR
1651: (CST.transfer_to_gl_flag is null
1652: AND EXISTS
1653: (select RR1.run_result_id
1654: from pay_run_results RR1
1655: , pay_run_results RR2
1656: , pay_element_entries_f EE1
1657: , pay_element_links_f EL1
1658: where RR1.assignment_action_id = raa.assignment_action_id

Line 1655: , pay_run_results RR2

1651: (CST.transfer_to_gl_flag is null
1652: AND EXISTS
1653: (select RR1.run_result_id
1654: from pay_run_results RR1
1655: , pay_run_results RR2
1656: , pay_element_entries_f EE1
1657: , pay_element_links_f EL1
1658: where RR1.assignment_action_id = raa.assignment_action_id
1659: and RR1.source_id = RR2.run_result_id

Line 1674: from pay_run_results RR1

1670: and RR1.run_result_id = nvl(CST.distributed_run_result_id,
1671: CST.run_result_id)
1672: UNION ALL
1673: select RR1.run_result_id
1674: from pay_run_results RR1
1675: , pay_element_entries_f EE1
1676: , pay_element_links_f EL1
1677: where RR1.assignment_action_id = raa.assignment_action_id
1678: and decode(r_action_type, 'B', nvl(RR1.element_entry_id, RR1.source_id),

Line 1694: FROM pay_run_results RR1,

1690: CST.run_result_id)
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

Line 1714: pay_run_results RR2

1710: )
1711: AND NOT EXISTS
1712: (SELECT null
1713: FROM pay_element_entries_f EE1,
1714: pay_run_results RR2
1715: WHERE RR2.source_id = EE1.element_entry_id
1716: AND RR1.source_type IN ('R', 'V')
1717: AND RR1.source_id = RR2.run_result_id
1718: AND least(nvl(RR2.end_date, ppa.date_earned), ppa.date_earned)