APPS.PAY_CA_T4_REG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 67: pay_assignment_actions paa

63: ff_archive_items fai2,
64: ff_archive_items fai3,
65: ff_archive_items fai4,
66: pay_payroll_actions ppa,
67: pay_assignment_actions paa
68: where ppa.payroll_action_id = :payroll_action_id
69: and fai1.user_entity_id = ' || l_uid_caeoy_tax_year ||
70: ' and fai1.value =
71: nvl(pay_ca_t4_reg.get_parameter(''TAX_YEAR'',

Line 179: pay_assignment_actions paa,

175: faic.context prov_cd,
176: paa.assignment_action_id,
177: paa.payroll_action_id
178: from per_assignments_f paf,
179: pay_assignment_actions paa,
180: ff_archive_items fai,
181: ff_contexts fc,
182: ff_archive_item_contexts faic
183: where paf.person_id between stperson

Line 211: pay_assignment_actions paa,

207: faic.context prov_cd,
208: paa.assignment_action_id,
209: paa.payroll_action_id
210: from per_assignments_f paf,
211: pay_assignment_actions paa,
212: ff_archive_items fai,
213: ff_contexts fc,
214: ff_archive_item_contexts faic
215: where paf.person_id between stperson

Line 245: pay_assignment_actions paa,

241: faic.context prov_cd,
242: paa.assignment_action_id,
243: paa.payroll_action_id
244: from per_assignments_f paf,
245: pay_assignment_actions paa,
246: ff_archive_items fai,
247: ff_archive_item_contexts faic,
248: ff_contexts fc
249: where paf.person_id >= stperson

Line 398: select pay_assignment_actions_s.nextval

394:
395: if (lv_negative_bal_flag = 'N' or
396: lv_negative_bal_flag is null) then
397:
398: select pay_assignment_actions_s.nextval
399: into lockingactid
400: from dual;
401:
402: hr_nonrun_asact.insact(lockingactid,

Line 417: update pay_assignment_actions paa

413: lpad(to_char(ln_arch_pact_id),14,0);
414:
415: hr_utility.trace('lv_serial_number :' ||lv_serial_number);
416:
417: update pay_assignment_actions paa
418: set paa.serial_number = lv_serial_number
419: where paa.assignment_action_id = lockingactid;
420:
421: else

Line 523: select pay_assignment_actions_s.nextval

519:
520: if (lv_negative_bal_flag = 'N' or
521: lv_negative_bal_flag is null) then
522:
523: select pay_assignment_actions_s.nextval
524: into lockingactid
525: from dual;
526:
527: hr_nonrun_asact.insact(lockingactid,

Line 544: update pay_assignment_actions paa

540: lpad(to_char(ln_arch_pact_id),14,0);
541:
542: hr_utility.trace('lv_serial_number :' ||lv_serial_number);
543:
544: update pay_assignment_actions paa
545: set paa.serial_number = lv_serial_number
546: where paa.assignment_action_id = lockingactid;
547:
548: else

Line 610: pay_assignment_actions paa1,

606: hr_all_organization_units hou1,
607: hr_locations_all loc,
608: per_all_people_f ppf,
609: per_all_assignments_f paf,
610: pay_assignment_actions paa1,
611: pay_payroll_actions ppa1
612: where ppa1.payroll_action_id = :pactid
613: and paa1.payroll_action_id = ppa1.payroll_action_id
614: and paa1.assignment_id = paf.assignment_id