APPS.PAY_US_HR_HELPDESK dependencies on PAY_ASSIGNMENT_ACTIONS

Line 23: ,pay_assignment_actions paa

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
27: where ppa.action_type = 'X'

Line 38: ,pay_assignment_actions paa1

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'
42: and ppa1.action_status = 'C'

Line 70: from pay_assignment_actions paa_xfr

66: -- Cursor to fetch run_type
67:
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

Line 71: ,pay_assignment_actions paa_prepay

67:
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

Line 216: p_assg_action_id pay_assignment_actions.assignment_action_id%type;

212:
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: