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_P45_PKG dependencies on PAY_RUN_RESULTS

Line 628: r2 PAY_RUN_RESULTS_N50)

624: -- Bug 6900025 added l_eff_date parameter to check proper financial year for fecting PAYE details.
625: CURSOR csr_max_run_result(l_element_id number,l_eff_date date) IS
626: SELECT /*+ ORDERED INDEX (assact2 PAY_ASSIGNMENT_ACTIONS_N51,
627: pact PAY_PAYROLL_ACTIONS_PK,
628: r2 PAY_RUN_RESULTS_N50)
629: USE_NL(assact2, pact, r2) */
630: to_number(substr(max(lpad(assact2.action_sequence,15,'0')||r2.source_type||
631: r2.run_result_id),17))
632: FROM pay_assignment_actions assact2,

Line 634: pay_run_results r2

630: to_number(substr(max(lpad(assact2.action_sequence,15,'0')||r2.source_type||
631: r2.run_result_id),17))
632: FROM pay_assignment_actions assact2,
633: pay_payroll_actions pact,
634: pay_run_results r2
635: WHERE assact2.assignment_id = p_assignment_id
636: AND r2.element_type_id+0 = l_element_id
637: AND r2.assignment_action_id = assact2.assignment_action_id
638: AND r2.status IN ('P', 'PA')

Line 792: ,pay_run_results r

788: from pay_assignment_actions a
789: ,pay_payroll_actions pact2
790: ,pay_balance_types t
791: ,pay_balance_feeds_f f
792: ,pay_run_results r
793: ,pay_run_result_values v
794: where t.balance_name in ('Taxable Pay','PAYE')
795: and t.legislation_code = 'GB'
796: and f.balance_type_id = t.balance_type_id

Line 917: , PAY_RUN_RESULTS PRR

913: (select 1
914: from PAY_BALANCE_FEEDS_F FEED
915: , PAY_BALANCE_TYPES PBT
916: , PAY_RUN_RESULT_VALUES PRRV
917: , PAY_RUN_RESULTS PRR
918: WHERE PBT.BALANCE_NAME in ('Taxable Pay', 'PAYE')
919: AND PBT.LEGISLATION_CODE = 'GB'
920: AND PBT.BALANCE_TYPE_ID = FEED.BALANCE_TYPE_ID
921: AND PRR.RUN_RESULT_ID = PRRV.RUN_RESULT_ID

Line 2131: pay_run_results prr,

2127: select 1 from dual where exists
2128: (select prrv.result_value
2129: from pay_input_values_f inv,
2130: pay_element_types_f type,
2131: pay_run_results prr,
2132: pay_run_result_values prrv
2133: where prrv.input_value_id = inv.input_value_id
2134: and inv.name = 'Tax Code'
2135: and prr.assignment_action_id = c_assignment_action_id

Line 3301: r2 PAY_RUN_RESULTS_N50)

3297: --
3298: CURSOR csr_max_run_result IS
3299: SELECT /*+ ORDERED INDEX (assact2 PAY_ASSIGNMENT_ACTIONS_N51,
3300: pact PAY_PAYROLL_ACTIONS_PK,
3301: r2 PAY_RUN_RESULTS_N50)
3302: USE_NL(assact2, pact, r2) */
3303: to_number(substr(max(lpad(assact2.action_sequence,15,'0')||r2.source_type||
3304: r2.run_result_id),17))
3305: FROM pay_assignment_actions assact2,

Line 3307: pay_run_results r2

3303: to_number(substr(max(lpad(assact2.action_sequence,15,'0')||r2.source_type||
3304: r2.run_result_id),17))
3305: FROM pay_assignment_actions assact2,
3306: pay_payroll_actions pact,
3307: pay_run_results r2
3308: WHERE assact2.assignment_id = l_assignment_id
3309: AND r2.element_type_id+0 = l_paye_element_id
3310: AND r2.assignment_action_id = assact2.assignment_action_id
3311: AND r2.status IN ('P', 'PA')