APPS.PQP_GB_AD_EE dependencies on PAY_RUN_RESULTS

Line 1770: FROM pay_run_results prr,

1766:
1767: CURSOR csr_get_reference
1768: IS
1769: SELECT nvl(prrv.result_value,'Unknown')
1770: FROM pay_run_results prr,
1771: pay_run_result_values prrv,
1772: pay_assignment_actions pac,
1773: pay_input_values_f piv ,
1774: pay_payroll_actions ppa

Line 1785: pay_run_results prr1,

1781: and ppa.action_type IN ('R','Q')
1782: AND ppa.payroll_action_id = pac.payroll_action_id
1783: AND pac.assignment_action_id = (SELECT max(pac1.assignment_action_id)
1784: FROM pay_assignment_actions pac1,
1785: pay_run_results prr1,
1786: pay_payroll_actions ppa1
1787: WHERE pac1.assignment_action_id = prr1.assignment_action_id
1788: AND ppa1.payroll_action_id = pac1.payroll_action_id
1789: AND prr1.source_id = p_element_entry_id

Line 1803: FROM pay_run_results PRR,

1799:
1800: CURSOR csr_get_results
1801: IS
1802: SELECT PRR.run_result_id
1803: FROM pay_run_results PRR,
1804: pay_assignment_actions ASA,
1805: pay_payroll_actions PPA
1806: WHERE PRR.source_id = p_element_entry_id
1807: AND PRR.source_type IN ('E', 'I')

Line 1815: FROM pay_run_results prr2

1811: and ppa.action_type IN ('R','Q')
1812: AND PPA.payroll_action_id = ASA.payroll_action_id
1813: -- Check whether the run_result has been revered.
1814: AND NOT EXISTS (SELECT null
1815: FROM pay_run_results prr2
1816: WHERE prr2.source_id = PRR.run_result_id
1817: AND prr2.source_type IN ('R', 'V'));
1818:
1819: