APPS.PAY_JP_PRE_TAX_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 29: from pay_assignment_actions

25: --
26: delete pay_action_interlocks
27: where locking_action_id in (
28: select assignment_action_id
29: from pay_assignment_actions
30: where payroll_action_id = p_payroll_action_id);
31: --
32: end remove_interlocks;
33: --

Line 123: p_chunk_number in pay_assignment_actions.chunk_number%TYPE)

119: procedure assignment_action_code(
120: p_payroll_action_id in pay_payroll_actions.payroll_action_id%TYPE,
121: p_start_person_id in number,
122: p_end_person_id in number,
123: p_chunk_number in pay_assignment_actions.chunk_number%TYPE)
124: is
125: c_proc constant varchar2(61) := c_package || 'assignment_action_code';
126: l_locking_action_id number;
127: l_assignment_id number;

Line 149: pay_assignment_actions paa,

145: between p_start_person_id and p_end_person_id
146: and pds.business_group_id + 0 = p_business_group_id
147: and asg.period_of_service_id = pds.period_of_service_id
148: ) v,
149: pay_assignment_actions paa,
150: pay_payroll_actions ppa
151: where paa.assignment_id = v.assignment_id
152: and paa.action_status = 'C'
153: and ppa.payroll_action_id = paa.payroll_action_id

Line 163: INDEX(XPAA PAY_ASSIGNMENT_ACTIONS_PK)

159: and not exists(
160: select /*+ ORDERED
161: USE_NL(PAAA PPAA)
162: INDEX(XPAI PAY_ACTION_INTERLOCKS_FK2)
163: INDEX(XPAA PAY_ASSIGNMENT_ACTIONS_PK)
164: INDEX(XPPA PAY_PAYROLL_ACTIONS_PK) */
165: null
166: from pay_action_interlocks xpai,
167: pay_assignment_actions xpaa,

Line 167: pay_assignment_actions xpaa,

163: INDEX(XPAA PAY_ASSIGNMENT_ACTIONS_PK)
164: INDEX(XPPA PAY_PAYROLL_ACTIONS_PK) */
165: null
166: from pay_action_interlocks xpai,
167: pay_assignment_actions xpaa,
168: pay_payroll_actions xppa
169: where xpai.locked_action_id = paa.assignment_action_id
170: and xpaa.assignment_action_id = xpai.locking_action_id
171: and xppa.payroll_action_id = xpaa.payroll_action_id

Line 199: select pay_assignment_actions_s.nextval

195: g_payroll_id) loop
196:
197: hr_utility.trace('assignment_id : ' || l_assact_rec.assignment_id);
198: --
199: select pay_assignment_actions_s.nextval
200: into l_locking_action_id
201: from dual;
202: --
203: hr_utility.trace('archive assignment_action_id : ' || l_locking_action_id);

Line 229: p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,

225: -- |-------------------------------------------------------------------|
226: -- |-------------------------< archive_code >--------------------------|
227: -- |-------------------------------------------------------------------|
228: procedure archive_code(
229: p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE,
230: p_effective_date in pay_payroll_actions.effective_date%TYPE)
231: is
232: c_proc constant varchar2(61) := c_package || 'archive_code';
233: l_errbuf varchar2(2000);

Line 277: from pay_assignment_actions

273: select 'Y'
274: from dual
275: where not exists(
276: select null
277: from pay_assignment_actions
278: where payroll_action_id = p_payroll_action_id
279: and action_status <> 'C');
280: begin
281: hr_utility.set_location('Entering: ' || c_proc, 10);