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 1649: pay_assignment_actions pac,

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

Line 1661: FROM pay_assignment_actions pac1,

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

Line 1681: pay_assignment_actions ASA,

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