APPS.PAY_CA_MAG_ROE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 145: pay_assignment_actions paa

141: p_sqlstr := 'select distinct person_id from
142: per_assignments_f paf,
143: ff_archive_items fai,
144: pay_payroll_actions ppa,
145: pay_assignment_actions paa
146: where
147: fai.user_entity_id = ' || l_roe_date_uid || ' and
148: fnd_date.canonical_to_date(fai.value) between
149: ppa.start_date and

Line 164: pay_assignment_actions paa,

160: p_sqlstr := 'select distinct paf.person_id from
161: per_assignments_f paf,
162: ff_archive_items fai,
163: pay_payroll_actions ppa,
164: pay_assignment_actions paa,
165: HR_ASSIGNMENT_SET_AMENDMENTS haa
166: where
167: fai.user_entity_id = ' || l_roe_date_uid || ' and
168: fnd_date.canonical_to_date(fai.value) between

Line 186: pay_assignment_actions paa

182: p_sqlstr := 'select distinct person_id from
183: per_assignments_f paf,
184: ff_archive_items fai,
185: pay_payroll_actions ppa,
186: pay_assignment_actions paa
187: where
188: fai.user_entity_id = ' || l_roe_date_uid || ' and
189: fnd_date.canonical_to_date(fai.value) between
190: ppa.start_date and

Line 247: l_assignment_id pay_assignment_actions.assignment_id%type;

243: l_roe_gre_id
244: ff_archive_items.user_entity_id%TYPE;
245: l_roe_payroll_id
246: ff_archive_items.user_entity_id%TYPE;
247: l_assignment_id pay_assignment_actions.assignment_id%type;
248: l_gre_id pay_assignment_actions.tax_unit_id%type;
249: l_payroll_id ff_archive_items.value%type;
250:
251: cursor cur_assignment_action_id is

Line 248: l_gre_id pay_assignment_actions.tax_unit_id%type;

244: ff_archive_items.user_entity_id%TYPE;
245: l_roe_payroll_id
246: ff_archive_items.user_entity_id%TYPE;
247: l_assignment_id pay_assignment_actions.assignment_id%type;
248: l_gre_id pay_assignment_actions.tax_unit_id%type;
249: l_payroll_id ff_archive_items.value%type;
250:
251: cursor cur_assignment_action_id is
252: select pay_assignment_actions_s.nextval

Line 252: select pay_assignment_actions_s.nextval

248: l_gre_id pay_assignment_actions.tax_unit_id%type;
249: l_payroll_id ff_archive_items.value%type;
250:
251: cursor cur_assignment_action_id is
252: select pay_assignment_actions_s.nextval
253: from dual;
254:
255:
256: lockingactid number;

Line 269: pay_assignment_actions paa,

265: paa.tax_unit_id gre_id,
266: fai2.value payroll_id
267: from
268: pay_payroll_actions ppa,
269: pay_assignment_actions paa,
270: ff_archive_items fai1,
271: ff_archive_items fai2,
272: per_assignments_f paf
273: where

Line 301: pay_assignment_actions paa,

297: paa.tax_unit_id gre_id,
298: fai2.value payroll_id
299: from
300: pay_payroll_actions ppa,
301: pay_assignment_actions paa,
302: ff_archive_items fai1,
303: ff_archive_items fai2,
304: per_assignments_f paf,
305: pay_population_ranges ppr

Line 334: pay_assignment_actions paa,

330: select
331: paa.assignment_action_id locked_action_id
332: from
333: pay_payroll_actions ppa,
334: pay_assignment_actions paa,
335: ff_archive_items fai1,
336: ff_archive_items fai2
337: where
338: ppa.report_type = 'ROE' and

Line 353: l_locked_action_id pay_assignment_actions.assignment_action_id%TYPE;

349: fai1.context1 = fai2.context1 and
350: fai2.user_entity_id = l_roe_payroll_id and
351: fai2.value = l_payroll_id;
352:
353: l_locked_action_id pay_assignment_actions.assignment_action_id%TYPE;
354:
355: cursor cur_already_locked is
356: select 'x' from pay_action_interlocks
357: where locked_action_id = l_locked_action_id;

Line 439: -- insert into pay_assignment_actions.

435: fetch cur_assignment_action_id
436: into lockingactid;
437: close cur_assignment_action_id;
438:
439: -- insert into pay_assignment_actions.
440:
441: hr_nonrun_asact.insact(lockingactid,l_assignment_id,
442: p_pactid,p_chunk,l_gre_id);
443: