APPS.PAY_MX_ANNUAL_WRI dependencies on PAY_ASSIGNMENT_ACTIONS

Line 165: pay_assignment_actions paa_sua

161: p_sqlstr := '
162: SELECT DISTINCT paf.person_id
163: FROM per_assignments_f paf,
164: pay_payroll_actions ppa_sua,
165: pay_assignment_actions paa_sua
166: WHERE ppa_sua.payroll_action_id = paa_sua.payroll_action_id
167: AND paa_sua.assignment_id = paf.assignment_id
168: AND fnd_date.canonical_to_date (pay_mx_utility.get_legi_param_val
169: (''END_DATE'',

Line 213: pay_assignment_actions paa_sua,

209: paf.primary_flag,
210: paf.effective_end_date
211: FROM per_assignments_f paf,
212: pay_payroll_actions ppa_sua,
213: pay_assignment_actions paa_sua,
214: pay_action_interlocks lck,
215: pay_action_information pai
216: WHERE ppa_sua.payroll_action_id = paa_sua.payroll_action_id
217: AND paa_sua.assignment_id = paf.assignment_id

Line 256: pay_assignment_actions paa_sua,

252: paf.primary_flag,
253: paf.effective_end_date
254: FROM per_assignments_f paf,
255: pay_payroll_actions ppa_sua,
256: pay_assignment_actions paa_sua,
257: pay_action_interlocks lck,
258: pay_action_information pai,
259: pay_population_ranges ppr
260: WHERE ppa_sua.payroll_action_id = paa_sua.payroll_action_id

Line 357: SELECT pay_assignment_actions_s.nextval

353: hr_utility_trace('Current person = '||ln_person_id);
354: hr_utility_trace('Previous person = '||ln_prev_person_id);
355:
356: IF (ln_person_id <> ln_prev_person_id) THEN
357: SELECT pay_assignment_actions_s.nextval
358: INTO ln_wri_asg_act
359: FROM dual;
360:
361: hr_utility_trace('Creating WRI assignment action '||

Line 436: FROM pay_assignment_actions paa,

432: AND pai.action_information23 IS NOT NULL; -- Absence end date
433:
434: CURSOR csr_person (cp_asg_act_id number) IS
435: SELECT DISTINCT paf.person_id
436: FROM pay_assignment_actions paa,
437: per_assignments_f paf
438: WHERE paf.assignment_id = paa.assignment_id
439: AND paa.assignment_action_id = cp_asg_act_id;
440:

Line 444: pay_assignment_actions paa,

440:
441: CURSOR csr_person_info (cp_person_id number) IS
442: SELECT pai.action_information_id
443: FROM pay_action_information pai,
444: pay_assignment_actions paa,
445: pay_payroll_actions ppa,
446: pay_action_interlocks lck,
447: pay_assignment_actions paa_arch,
448: pay_payroll_actions ppa_arch

Line 447: pay_assignment_actions paa_arch,

443: FROM pay_action_information pai,
444: pay_assignment_actions paa,
445: pay_payroll_actions ppa,
446: pay_action_interlocks lck,
447: pay_assignment_actions paa_arch,
448: pay_payroll_actions ppa_arch
449: WHERE paa.payroll_action_id = ppa.payroll_action_id
450: AND fnd_number.canonical_to_number(
451: pay_mx_utility.get_legi_param_val('GRE',

Line 482: pay_assignment_actions paa_arch

478: FROM pay_action_information pai,
479: pay_action_interlocks lck_sua,
480: pay_action_interlocks lck_arch,
481: pay_payroll_actions ppa_arch,
482: pay_assignment_actions paa_arch
483: WHERE lck_sua.locking_action_id = cp_wri_asg_act
484: AND lck_sua.locked_action_id = lck_arch.locking_action_id
485: AND lck_arch.locked_action_id = pai.action_context_id
486: AND pai.action_information_category = 'MX SS PERSON INFORMATION'

Line 601: pay_assignment_actions paa_arch,

597: SELECT pai.action_information_id
598: FROM pay_action_information pai,
599: pay_action_interlocks lck_sua,
600: pay_action_interlocks lck_arch,
601: pay_assignment_actions paa_arch,
602: pay_assignment_actions paa_wri
603: WHERE paa_wri.payroll_action_id =
604: pay_magtape_generic.get_parameter_value ('PAYROLL_ACTION_ID')
605: AND lck_sua.locking_action_id = paa_wri.assignment_action_id

Line 602: pay_assignment_actions paa_wri

598: FROM pay_action_information pai,
599: pay_action_interlocks lck_sua,
600: pay_action_interlocks lck_arch,
601: pay_assignment_actions paa_arch,
602: pay_assignment_actions paa_wri
603: WHERE paa_wri.payroll_action_id =
604: pay_magtape_generic.get_parameter_value ('PAYROLL_ACTION_ID')
605: AND lck_sua.locking_action_id = paa_wri.assignment_action_id
606: AND lck_sua.locked_action_id = lck_arch.locking_action_id