APPS.PQP_GB_AD_EE dependencies on PAY_RUN_RESULTS

Line 1647: FROM pay_run_results prr,

1643:
1644: CURSOR csr_get_reference
1645: IS
1646: SELECT nvl(prrv.result_value,'Unknown')
1647: FROM pay_run_results prr,
1648: pay_run_result_values prrv,
1649: pay_assignment_actions pac,
1650: pay_input_values_f piv ,
1651: pay_payroll_actions ppa

Line 1662: pay_run_results prr1,

1658: and ppa.action_type IN ('R','Q')
1659: AND ppa.payroll_action_id = pac.payroll_action_id
1660: AND pac.assignment_action_id = (SELECT max(pac1.assignment_action_id)
1661: FROM pay_assignment_actions pac1,
1662: pay_run_results prr1,
1663: pay_payroll_actions ppa1
1664: WHERE pac1.assignment_action_id = prr1.assignment_action_id
1665: AND ppa1.payroll_action_id = pac1.payroll_action_id
1666: AND prr1.source_id = p_element_entry_id

Line 1680: FROM pay_run_results PRR,

1676:
1677: CURSOR csr_get_results
1678: IS
1679: SELECT PRR.run_result_id
1680: FROM pay_run_results PRR,
1681: pay_assignment_actions ASA,
1682: pay_payroll_actions PPA
1683: WHERE PRR.source_id = p_element_entry_id
1684: AND PRR.source_type IN ('E', 'I')

Line 1692: FROM pay_run_results prr2

1688: and ppa.action_type IN ('R','Q')
1689: AND PPA.payroll_action_id = ASA.payroll_action_id
1690: -- Check whether the run_result has been revered.
1691: AND NOT EXISTS (SELECT null
1692: FROM pay_run_results prr2
1693: WHERE prr2.source_id = PRR.run_result_id
1694: AND prr2.source_type IN ('R', 'V'));
1695:
1696: l_element_name pay_element_types_f.element_name%TYPE;