APPS.PQP_GB_AD_EE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 204: pay_assignment_actions paa,

200: -- in next tax year for car and mile element
201: CURSOR c_chk_payrun IS
202: select max(ppa.effective_date) effective_date
203: from pay_payroll_actions ppa,
204: pay_assignment_actions paa,
205: per_assignments_f paf
206: WHERE paf.person_id =(SELECT distinct person_id from per_assignments_f
207: where assignment_id =p_assignment_id_o)
208: AND paf.assignment_id=paa.assignment_id

Line 1772: pay_assignment_actions pac,

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
1775: WHERE prr.run_result_id = prrv.run_result_id
1776: AND prr.entry_type = 'E'

Line 1784: FROM pay_assignment_actions pac1,

1780: AND pac.action_status IN ('C')
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

Line 1804: pay_assignment_actions ASA,

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')
1808: AND PRR.status IN ('P', 'PA', 'R', 'O')