APPS.PAY_KW_PIFSS dependencies on PAY_PAYROLL_ACTIONS

Line 20: 'pay_payroll_actions ppa '||

16: -- the string, and the statement must be, order by person_id
17: --
18: sqlstr := 'select distinct person_id '||
19: 'from per_people_f ppf, '||
20: 'pay_payroll_actions ppa '||
21: 'where ppa.payroll_action_id = :payroll_action_id '||
22: 'and ppa.business_group_id = ppf.business_group_id '||
23: 'order by ppf.person_id';
24: --

Line 29: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

25: hr_utility.set_location(' Leaving: '||l_proc,100);
26: END range_cursor;
27: --
28: procedure assignment_action_code
29: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
30: p_start_person_id in per_all_people_f.person_id%type,
31: p_end_person_id in per_all_people_f.person_id%type,
32: p_chunk in number) is
33: v_next_action_id pay_assignment_actions.assignment_action_id%type;

Line 35: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,

31: p_end_person_id in per_all_people_f.person_id%type,
32: p_chunk in number) is
33: v_next_action_id pay_assignment_actions.assignment_action_id%type;
34: cursor process_assignments
35: (c_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
36: c_start_person_id in per_all_people_f.person_id%type,
37: c_end_person_id in per_all_people_f.person_id%type) is
38: select distinct a.assignment_id,
39: pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id,

Line 43: pay_payroll_actions pa,

39: pay_core_utils.get_parameter('ARCHIVE_ID', pa.legislative_parameters) archive_action_id,
40: ppac.assignment_action_id
41: from per_assignments_f a,
42: per_people_f p,
43: pay_payroll_actions pa,
44: pay_payroll_actions ppa,
45: pay_assignment_actions ppac
46: where pa.payroll_action_id = c_payroll_action_id
47: and p.person_id between c_start_person_id and c_end_person_id

Line 44: pay_payroll_actions ppa,

40: ppac.assignment_action_id
41: from per_assignments_f a,
42: per_people_f p,
43: pay_payroll_actions pa,
44: pay_payroll_actions ppa,
45: pay_assignment_actions ppac
46: where pa.payroll_action_id = c_payroll_action_id
47: and p.person_id between c_start_person_id and c_end_person_id
48: and p.person_id = a.person_id

Line 58: pay_payroll_Actions ppaa

54: and ppa.action_status = 'C'
55: and ppac.assignment_action_id in
56: (select max(ppac1.assignment_action_id)
57: from pay_assignment_actions ppac1,
58: pay_payroll_Actions ppaa
59: where ppaa.action_type ='X'
60: and ppaa.action_status ='C'
61: and ppaa.report_type ='KW_PIFSS_REPORT'
62: and ppaa.payroll_Action_id = ppac1.payroll_action_id