APPS.PAY_CA_T4A_REG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 61: pay_assignment_actions paa

57: from ff_archive_items fai1,
58: ff_archive_items fai2,
59: ff_archive_items fai3,
60: pay_payroll_actions ppa,
61: pay_assignment_actions paa
62: where ppa.payroll_action_id = :payroll_action_id
63: and fai1.user_entity_id = ' || l_uid_tax_year ||
64: ' and fai1.value =
65: nvl(pay_ca_t4a_reg.get_parameter(''TAX_YEAR'',ppa.legislative_parameters),fai1.value)

Line 149: pay_assignment_actions paa

145: paa.assignment_action_id,
146: paa.payroll_action_id
147: from
148: per_assignments_f paf,
149: pay_assignment_actions paa
150: where
151: paf.person_id >= stperson and
152: paf.person_id <= endperson and
153: paf.primary_flag = 'Y' and

Line 173: pay_assignment_actions paa

169: select paf.assignment_id assignment_id,
170: paa.assignment_action_id,
171: paa.payroll_action_id
172: from per_assignments_f paf,
173: pay_assignment_actions paa
174: where paf.person_id between stperson
175: and endperson
176: and paf.primary_flag = 'Y'
177: and paf.assignment_type = 'E'

Line 200: pay_assignment_actions paa

196: paa.assignment_action_id,
197: paa.payroll_action_id
198: from
199: per_assignments_f paf,
200: pay_assignment_actions paa
201: where
202: paf.person_id >= stperson and
203: paf.person_id <= endperson and
204: paf.primary_flag = 'Y' and

Line 327: select pay_assignment_actions_s.nextval

323:
324: hr_utility.trace('Begining of if part loop for c_all_asg 10 '||
325: to_char(l_asg_id));
326:
327: select pay_assignment_actions_s.nextval
328: into lockingactid
329: from dual;
330:
331: hr_nonrun_asact.insact(lockingactid,

Line 347: update pay_assignment_actions paa

343: lpad(to_char(ln_arch_pact_id),14,0);
344:
345: hr_utility.trace('lv_serial_number :' ||lv_serial_number);
346:
347: update pay_assignment_actions paa
348: set paa.serial_number = lv_serial_number
349: where paa.assignment_action_id = lockingactid;
350:
351: end loop;

Line 411: select pay_assignment_actions_s.nextval

407: ln_arch_pact_id;
408: exit when c_all_asg%notfound;
409: end if;
410:
411: select pay_assignment_actions_s.nextval
412: into lockingactid
413: from dual;
414:
415: hr_nonrun_asact.insact(lockingactid,

Line 432: update pay_assignment_actions paa

428: lpad(to_char(ln_arch_pact_id),14,0);
429:
430: hr_utility.trace('lv_serial_number :' ||lv_serial_number);
431:
432: update pay_assignment_actions paa
433: set paa.serial_number = lv_serial_number
434: where paa.assignment_action_id = lockingactid;
435:
436: end loop;

Line 474: pay_assignment_actions paa1,

470: hr_all_organization_units hou1,
471: hr_locations_all loc,
472: per_all_people_f ppf,
473: per_all_assignments_f paf,
474: pay_assignment_actions paa1,
475: pay_payroll_actions ppa1
476: where ppa1.payroll_action_id = :pactid
477: and paa1.payroll_action_id = ppa1.payroll_action_id
478: and paa1.assignment_id = paf.assignment_id