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 163: 40.7 alogue 19-JUN-1997 Catered for pay_run_results source_id

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

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

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

Line 556: pay_run_results rr,

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

Line 583: from pay_run_results RR1

579: and ppa.date_earned between IV.effective_start_date
580: and IV.effective_end_date
581: AND EXISTS
582: (select RR1.run_result_id
583: from pay_run_results RR1
584: , pay_run_results RR2
585: , pay_element_entries_f EE1
586: , pay_element_links_f EL1
587: where RR1.assignment_action_id = pa2.assignment_action_id

Line 584: , pay_run_results RR2

580: and IV.effective_end_date
581: AND EXISTS
582: (select RR1.run_result_id
583: from pay_run_results RR1
584: , pay_run_results RR2
585: , pay_element_entries_f EE1
586: , pay_element_links_f EL1
587: where RR1.assignment_action_id = pa2.assignment_action_id
588: and RR1.source_id = RR2.run_result_id

Line 602: from pay_run_results RR1

598: and RR1.run_result_id = nvl(CST.distributed_run_result_id,
599: CST.run_result_id)
600: UNION ALL
601: select RR1.run_result_id
602: from pay_run_results RR1
603: , pay_element_entries_f EE1
604: , pay_element_links_f EL1
605: where RR1.assignment_action_id = pa2.assignment_action_id
606: and RR1.source_id = EE1.element_entry_id

Line 619: FROM pay_run_results RR1,

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

Line 639: FROM pay_run_results RR2,

635: AND EE1.effective_end_date
636: )
637: AND NOT EXISTS
638: (SELECT null
639: FROM pay_run_results RR2,
640: pay_element_entries_f EE1
641: WHERE RR2.source_id = EE1.element_entry_id
642: AND RR1.source_type IN (''R'', ''V'')
643: AND RR1.source_id = RR2.run_result_id

Line 760: pay_run_results rr,

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

Line 787: from pay_run_results RR1

783: and ppa.date_earned between IV.effective_start_date
784: and IV.effective_end_date
785: AND EXISTS
786: (select RR1.run_result_id
787: from pay_run_results RR1
788: , pay_run_results RR2
789: , pay_element_entries_f EE1
790: , pay_element_links_f EL1
791: where RR1.assignment_action_id = pa2.assignment_action_id

Line 788: , pay_run_results RR2

784: and IV.effective_end_date
785: AND EXISTS
786: (select RR1.run_result_id
787: from pay_run_results RR1
788: , pay_run_results RR2
789: , pay_element_entries_f EE1
790: , pay_element_links_f EL1
791: where RR1.assignment_action_id = pa2.assignment_action_id
792: and RR1.source_id = RR2.run_result_id

Line 806: from pay_run_results RR1

802: and RR1.run_result_id = nvl(CST.distributed_run_result_id,
803: CST.run_result_id)
804: UNION ALL
805: select RR1.run_result_id
806: from pay_run_results RR1
807: , pay_element_entries_f EE1
808: , pay_element_links_f EL1
809: where RR1.assignment_action_id = pa2.assignment_action_id
810: and RR1.source_id = EE1.element_entry_id

Line 823: FROM pay_run_results RR1,

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

Line 843: FROM pay_run_results RR2,

839: AND EE1.effective_end_date
840: )
841: AND NOT EXISTS
842: (SELECT null
843: FROM pay_run_results RR2,
844: pay_element_entries_f EE1
845: WHERE RR2.source_id = EE1.element_entry_id
846: AND RR1.source_type IN (''R'', ''V'')
847: AND RR1.source_id = RR2.run_result_id

Line 1647: pay_run_results rr,

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

Line 1673: from pay_run_results RR1

1669: OR
1670: (CST.transfer_to_gl_flag is null
1671: AND EXISTS
1672: (select RR1.run_result_id
1673: from pay_run_results RR1
1674: , pay_run_results RR2
1675: , pay_element_entries_f EE1
1676: , pay_element_links_f EL1
1677: where RR1.assignment_action_id = raa.assignment_action_id

Line 1674: , pay_run_results RR2

1670: (CST.transfer_to_gl_flag is null
1671: AND EXISTS
1672: (select RR1.run_result_id
1673: from pay_run_results RR1
1674: , pay_run_results RR2
1675: , pay_element_entries_f EE1
1676: , pay_element_links_f EL1
1677: where RR1.assignment_action_id = raa.assignment_action_id
1678: and RR1.source_id = RR2.run_result_id

Line 1693: from pay_run_results RR1

1689: and RR1.run_result_id = nvl(CST.distributed_run_result_id,
1690: CST.run_result_id)
1691: UNION ALL
1692: select RR1.run_result_id
1693: from pay_run_results RR1
1694: , pay_element_entries_f EE1
1695: , pay_element_links_f EL1
1696: where RR1.assignment_action_id = raa.assignment_action_id
1697: and decode(r_action_type, 'B', nvl(RR1.element_entry_id, RR1.source_id),

Line 1713: FROM pay_run_results RR1,

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

Line 1733: pay_run_results RR2

1729: )
1730: AND NOT EXISTS
1731: (SELECT null
1732: FROM pay_element_entries_f EE1,
1733: pay_run_results RR2
1734: WHERE RR2.source_id = EE1.element_entry_id
1735: AND RR1.source_type IN ('R', 'V')
1736: AND RR1.source_id = RR2.run_result_id
1737: AND least(nvl(RR2.end_date, ppa.date_earned), ppa.date_earned)