APPS.PQP_GB_AD_EE dependencies on PAY_PAYROLL_ACTIONS

Line 50: FROM pay_payroll_actions act

46: INTO l_py_ed
47: FROM per_time_periods time
48: WHERE time.payroll_id = l_asg_py_id
49: AND time.end_date > ( SELECT MAX(effective_date)
50: FROM pay_payroll_actions act
51: WHERE act.payroll_id =l_asg_py_id
52: and act.action_status='C')
53: AND ROWNUM = 1;
54:

Line 203: from pay_payroll_actions ppa,

199: --Checks whether the payroll has been run
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)

Line 1651: pay_payroll_actions ppa

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'
1654: AND PRR.source_type IN ('E', 'I')
1655: AND prr.source_id = p_element_entry_id

Line 1663: pay_payroll_actions ppa1

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

Line 1682: pay_payroll_actions PPA

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')
1686: AND ASA.assignment_action_id = PRR.assignment_action_id