APPS.PAY_P45_PKG dependencies on PAY_RUN_RESULTS

Line 571: r2 PAY_RUN_RESULTS_N50)

567: -- Bug 6900025 added l_eff_date parameter to check proper financial year for fecting PAYE details.
568: CURSOR csr_max_run_result(l_element_id number,l_eff_date date) IS
569: SELECT /*+ ORDERED INDEX (assact2 PAY_ASSIGNMENT_ACTIONS_N51,
570: pact PAY_PAYROLL_ACTIONS_PK,
571: r2 PAY_RUN_RESULTS_N50)
572: USE_NL(assact2, pact, r2) */
573: to_number(substr(max(lpad(assact2.action_sequence,15,'0')||r2.source_type||
574: r2.run_result_id),17))
575: FROM pay_assignment_actions assact2,

Line 577: pay_run_results r2

573: to_number(substr(max(lpad(assact2.action_sequence,15,'0')||r2.source_type||
574: r2.run_result_id),17))
575: FROM pay_assignment_actions assact2,
576: pay_payroll_actions pact,
577: pay_run_results r2
578: WHERE assact2.assignment_id = p_assignment_id
579: AND r2.element_type_id+0 = l_element_id
580: AND r2.assignment_action_id = assact2.assignment_action_id
581: AND r2.status IN ('P', 'PA')

Line 731: ,pay_run_results r

727: from pay_assignment_actions a
728: ,pay_payroll_actions pact2
729: ,pay_balance_types t
730: ,pay_balance_feeds_f f
731: ,pay_run_results r
732: ,pay_run_result_values v
733: where t.balance_name in ('Taxable Pay','PAYE')
734: and t.legislation_code = 'GB'
735: and f.balance_type_id = t.balance_type_id

Line 839: , PAY_RUN_RESULTS PRR

835: (select 1
836: from PAY_BALANCE_FEEDS_F FEED
837: , PAY_BALANCE_TYPES PBT
838: , PAY_RUN_RESULT_VALUES PRRV
839: , PAY_RUN_RESULTS PRR
840: WHERE PBT.BALANCE_NAME in ('Taxable Pay', 'PAYE')
841: AND PBT.LEGISLATION_CODE = 'GB'
842: AND PBT.BALANCE_TYPE_ID = FEED.BALANCE_TYPE_ID
843: AND PRR.RUN_RESULT_ID = PRRV.RUN_RESULT_ID

Line 2009: pay_run_results prr,

2005: select 1 from dual where exists
2006: (select prrv.result_value
2007: from pay_input_values_f inv,
2008: pay_element_types_f type,
2009: pay_run_results prr,
2010: pay_run_result_values prrv
2011: where prrv.input_value_id = inv.input_value_id
2012: and inv.name = 'Tax Code'
2013: and prr.assignment_action_id = c_assignment_action_id

Line 2916: r2 PAY_RUN_RESULTS_N50)

2912: --
2913: CURSOR csr_max_run_result IS
2914: SELECT /*+ ORDERED INDEX (assact2 PAY_ASSIGNMENT_ACTIONS_N51,
2915: pact PAY_PAYROLL_ACTIONS_PK,
2916: r2 PAY_RUN_RESULTS_N50)
2917: USE_NL(assact2, pact, r2) */
2918: to_number(substr(max(lpad(assact2.action_sequence,15,'0')||r2.source_type||
2919: r2.run_result_id),17))
2920: FROM pay_assignment_actions assact2,

Line 2922: pay_run_results r2

2918: to_number(substr(max(lpad(assact2.action_sequence,15,'0')||r2.source_type||
2919: r2.run_result_id),17))
2920: FROM pay_assignment_actions assact2,
2921: pay_payroll_actions pact,
2922: pay_run_results r2
2923: WHERE assact2.assignment_id = l_assignment_id
2924: AND r2.element_type_id+0 = l_paye_element_id
2925: AND r2.assignment_action_id = assact2.assignment_action_id
2926: AND r2.status IN ('P', 'PA')