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 1774: pay_payroll_actions ppa

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

Line 1786: pay_payroll_actions ppa1

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

Line 1805: pay_payroll_actions PPA

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