[Home] [Help]
322: hr_utility_trace ('gn_legal_er_id = '|| gn_legal_er_id);
323:
324: p_sqlstr := '
325: SELECT DISTINCT to_number(paa_arch.serial_number)
326: FROM pay_assignment_actions paa_arch
327: ,pay_payroll_actions ppa_arch
328: WHERE ppa_arch.business_group_id = '|| gn_business_group_id ||'
329: AND ppa_arch.report_type = ''MX_YREND_ARCHIVE''
330: AND ppa_arch.report_qualifier = ''MX''
363: SELECT paa_arch.assignment_action_id
364: ,paa_arch.assignment_id
365: ,paa_arch.serial_number person_id
366: ,ppa_arch.payroll_action_id
367: FROM pay_assignment_actions paa_arch,
368: pay_payroll_actions ppa_arch
369: WHERE ppa_arch.business_group_id = cp_business_group_id
370: AND ppa_arch.report_type = 'MX_YREND_ARCHIVE'
371: AND ppa_arch.report_qualifier = 'MX'
388: SELECT paa_arch.assignment_action_id
389: ,paa_arch.assignment_id
390: ,paa_arch.serial_number person_id
391: ,ppa_arch.payroll_action_id
392: FROM pay_assignment_actions paa_arch,
393: pay_payroll_actions ppa_arch,
394: pay_population_ranges ppr
395: WHERE ppa_arch.business_group_id = cp_business_group_id
396: AND ppa_arch.report_type = 'MX_YREND_ARCHIVE'
494: hr_utility_trace('Previous person = '||ln_prev_person_id);
495:
496: IF (ln_person_id <> ln_prev_person_id) THEN
497:
498: SELECT pay_assignment_actions_s.nextval
499: INTO ln_mag_asg_act_id
500: FROM dual;
501:
502: hr_utility_trace('Creating magtape assignment action '||
731: ,ltrim(rtrim(PATERNAL_LAST_NAME)) ||' '
732: ||ltrim(rtrim(MATERNAL_LAST_NAME)) ||' '
733: ||ltrim(rtrim(NAMES)) FULL_NAME
734: FROM pay_mx_isr_tax_format37_v dim
735: ,pay_assignment_actions paa
736: ,pay_action_interlocks pai
737: WHERE dim.payroll_action_id = paa.payroll_action_id
738: AND dim.assignment_action_id = paa.assignment_action_id /*7951969*/
739: AND dim.person_id = to_number(paa.serial_number)