APPS.PAY_MX_FORMAT_2D dependencies on PAY_ASSIGNMENT_ACTIONS

Line 314: FROM pay_assignment_actions paa_arch

310: hr_utility_trace ('gn_legal_er_id = '|| gn_legal_er_id);
311:
312: p_sqlstr := '
313: SELECT DISTINCT paa_arch.serial_number
314: FROM pay_assignment_actions paa_arch
315: ,pay_payroll_actions ppa_arch
316: WHERE ppa_arch.business_group_id = '|| gn_business_group_id ||'
317: AND ppa_arch.report_type = ''MX_YREND_ARCHIVE''
318: AND ppa_arch.report_qualifier = ''MX''

Line 355: FROM pay_assignment_actions paa_arch,

351: SELECT paa_arch.assignment_action_id
352: ,paa_arch.assignment_id
353: ,paa_arch.serial_number person_id
354: ,ppa_arch.payroll_action_id
355: FROM pay_assignment_actions paa_arch,
356: pay_payroll_actions ppa_arch
357: WHERE ppa_arch.business_group_id = cp_business_group_id
358: AND ppa_arch.report_type = 'MX_YREND_ARCHIVE'
359: AND ppa_arch.report_qualifier = 'MX'

Line 380: FROM pay_assignment_actions paa_arch,

376: SELECT paa_arch.assignment_action_id
377: ,paa_arch.assignment_id
378: ,paa_arch.serial_number person_id
379: ,ppa_arch.payroll_action_id
380: FROM pay_assignment_actions paa_arch,
381: pay_payroll_actions ppa_arch,
382: pay_population_ranges ppr
383: WHERE ppa_arch.business_group_id = cp_business_group_id
384: AND ppa_arch.report_type = 'MX_YREND_ARCHIVE'

Line 487: SELECT pay_assignment_actions_s.nextval

483: hr_utility_trace('Previous person = '||ln_prev_person_id);
484:
485: IF (ln_person_id <> ln_prev_person_id) THEN
486:
487: SELECT pay_assignment_actions_s.nextval
488: INTO ln_mag_asg_act_id
489: FROM dual;
490:
491: hr_utility_trace('Creating magtape assignment action '||

Line 579: ,pay_assignment_actions paa

575: ,0 OTHER_EARNINGS
576: ,nvl(TOTAL_SUBJECT_EARNINGS,0)+
577: nvl(TOTAL_EXEMPT_EARNINGS,0) TOTAL_EARNINGS
578: FROM pay_mx_isr_tax_format37_v format2d
579: ,pay_assignment_actions paa
580: ,pay_action_interlocks pai
581: WHERE format2d.payroll_action_id = paa.payroll_action_id
582: AND format2d.person_id = to_number(paa.serial_number)
583: AND paa.assignment_action_id = pai.locked_action_id

Line 596: FROM pay_assignment_actions paa

592: and legislation_info1 = 'GMW';
593:
594: CURSOR c_pact_id (cp_assignment_action_id NUMBER) IS
595: SELECT paa.payroll_action_id
596: FROM pay_assignment_actions paa
597: WHERE paa.assignment_action_id = cp_assignment_action_id;
598:
599: l_proc_name varchar2(100);
600: l_xml BLOB;