APPS.PAY_US_HR_HELPDESK dependencies on PAY_PAYROLL_ACTIONS

Line 22: from pay_payroll_actions ppa

18: ppa.payroll_action_id
19: ,paa.assignment_id
20: ,paa.assignment_action_id
21: ,paf.location_id
22: from pay_payroll_actions ppa
23: ,pay_assignment_actions paa
24: ,per_assignments_f paf
25: ,per_people_f ppf
26: ,hr_lookups hl

Line 37: from pay_payroll_actions ppa1

33: and paa.assignment_id = paf.assignment_id
34: and paf.person_id = ppf.person_id
35: and ppf.person_id = l_person_id
36: and ppa.effective_date = (select max(ppa1.effective_date)
37: from pay_payroll_actions ppa1
38: ,pay_assignment_actions paa1
39: ,hr_lookups hl1
40: where ppa1.effective_date <= l_eff_date
41: and ppa1.action_type = 'X'

Line 72: ,pay_payroll_actions ppa_prepay

68: cursor csr_run_type(p_assignment_action_id NUMBER) is
69: select prt.run_type_name
70: from pay_assignment_actions paa_xfr
71: ,pay_assignment_actions paa_prepay
72: ,pay_payroll_actions ppa_prepay
73: ,pay_run_types_f prt
74: where paa_xfr.assignment_action_id = p_assignment_action_id
75: and (INSTR(paa_xfr.serial_number, 'PY') <> 0
76: or INSTR(paa_xfr.serial_number, 'UY') <> 0)

Line 217: p_pyrl_action_id pay_payroll_actions.payroll_action_id%type;

213: p_location_name varchar2(100);
214:
215: p_assignment_id per_all_assignments_f.assignment_id%type;
216: p_assg_action_id pay_assignment_actions.assignment_action_id%type;
217: p_pyrl_action_id pay_payroll_actions.payroll_action_id%type;
218:
219: p_cnt number;
220:
221: p_location_id number;