APPS.PAY_SA_HIST_ARCH_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 16: from pay_payroll_actions

12:
13: cursor csr_parameter_info(p_pact_id number,
14: p_token char) is
15: select pay_core_utils.get_parameter(p_token,legislative_parameters)
16: from pay_payroll_actions
17: where payroll_action_id = p_pact_id;
18:
19: l_token_value varchar2(50) := null;
20:

Line 73: pay_payroll_actions ppa

69: --
70: hr_utility.trace('Range Cursor Not using Payroll Restriction');
71: sqlstr := 'SELECT DISTINCT person_id
72: FROM per_people_f ppf,
73: pay_payroll_actions ppa
74: WHERE ppa.payroll_action_id = :payroll_action_id
75: AND ppa.business_group_id +0= ppf.business_group_id
76: ORDER BY ppf.person_id';
77: else

Line 84: pay_payroll_actions ppa,

80: --
81: hr_utility.trace('Range Cursor using Payroll Restriction');
82: sqlstr := 'SELECT DISTINCT ppf.person_id
83: FROM per_all_people_f ppf,
84: pay_payroll_actions ppa,
85: per_all_assignments_f paaf
86: WHERE ppa.payroll_action_id = :payroll_action_id
87: AND ppf.business_group_id +0 = ppa.business_group_id
88: AND paaf.person_id = ppf.person_id

Line 127: pay_payroll_actions ppa,

123: select distinct paa.assignment_action_id,
124: paaf.assignment_id,
125: ppa.effective_date
126: from per_all_assignments_f paaf,
127: pay_payroll_actions ppa,
128: pay_assignment_actions paa,
129: pay_action_interlocks lck,
130: pay_payroll_actions ppa1,
131: pay_assignment_actions paa1

Line 130: pay_payroll_actions ppa1,

126: from per_all_assignments_f paaf,
127: pay_payroll_actions ppa,
128: pay_assignment_actions paa,
129: pay_action_interlocks lck,
130: pay_payroll_actions ppa1,
131: pay_assignment_actions paa1
132: where paa.SOURCE_ACTION_ID is null
133: and paaf.person_id between stperson and endperson
134: and ppa.report_type = 'SA_ARCHIVE'

Line 175: from pay_payroll_actions

171: get_parameters(pactid,'P_END_DATE',l_end_date);
172:
173: select business_group_id
174: into l_bg_id
175: from pay_payroll_actions
176: where payroll_action_id = pactid;
177:
178: hr_utility.set_location('l_payroll_id :' ||l_payroll_id ,10);
179: hr_utility.set_location('l_start_date :' ||l_start_date ,10);

Line 238: ,pay_payroll_actions prepay_payact

234: ,run_assact.assignment_action_id run_assact_id
235: ,prepay_payact.effective_date prepay_effective_date
236: FROM pay_action_interlocks archive_intlck
237: ,pay_assignment_actions prepay_assact
238: ,pay_payroll_actions prepay_payact
239: ,pay_action_interlocks prepay_intlck
240: ,pay_assignment_actions run_assact
241: ,pay_payroll_actions run_payact
242: WHERE archive_intlck.locking_action_id = p_locking_action_id

Line 241: ,pay_payroll_actions run_payact

237: ,pay_assignment_actions prepay_assact
238: ,pay_payroll_actions prepay_payact
239: ,pay_action_interlocks prepay_intlck
240: ,pay_assignment_actions run_assact
241: ,pay_payroll_actions run_payact
242: WHERE archive_intlck.locking_action_id = p_locking_action_id
243: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
244: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id
245: AND prepay_payact.action_type IN ('U','P')

Line 259: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;

255: WHERE assignment_Action_id = p_assignment_action_id;
256:
257: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
258: l_run_asg_action_id pay_assignment_actions.assignment_action_id%type;
259: l_payroll_action_id pay_payroll_actions.payroll_action_id%type;
260: l_assignment_id number;
261: l_effective_date date;
262:
263: begin