APPS.PAY_MX_DIM_MAG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 320: FROM pay_assignment_actions paa_arch

316: hr_utility_trace ('gn_legal_er_id = '|| gn_legal_er_id);
317:
318: p_sqlstr := '
319: SELECT DISTINCT to_number(paa_arch.serial_number)
320: FROM pay_assignment_actions paa_arch
321: ,pay_payroll_actions ppa_arch
322: WHERE ppa_arch.business_group_id = '|| gn_business_group_id ||'
323: AND ppa_arch.report_type = ''MX_YREND_ARCHIVE''
324: AND ppa_arch.report_qualifier = ''MX''

Line 361: FROM pay_assignment_actions paa_arch,

357: SELECT paa_arch.assignment_action_id
358: ,paa_arch.assignment_id
359: ,paa_arch.serial_number person_id
360: ,ppa_arch.payroll_action_id
361: FROM pay_assignment_actions paa_arch,
362: pay_payroll_actions ppa_arch
363: WHERE ppa_arch.business_group_id = cp_business_group_id
364: AND ppa_arch.report_type = 'MX_YREND_ARCHIVE'
365: AND ppa_arch.report_qualifier = 'MX'

Line 386: FROM pay_assignment_actions paa_arch,

382: SELECT paa_arch.assignment_action_id
383: ,paa_arch.assignment_id
384: ,paa_arch.serial_number person_id
385: ,ppa_arch.payroll_action_id
386: FROM pay_assignment_actions paa_arch,
387: pay_payroll_actions ppa_arch,
388: pay_population_ranges ppr
389: WHERE ppa_arch.business_group_id = cp_business_group_id
390: AND ppa_arch.report_type = 'MX_YREND_ARCHIVE'

Line 492: SELECT pay_assignment_actions_s.nextval

488: hr_utility_trace('Previous person = '||ln_prev_person_id);
489:
490: IF (ln_person_id <> ln_prev_person_id) THEN
491:
492: SELECT pay_assignment_actions_s.nextval
493: INTO ln_mag_asg_act_id
494: FROM dual;
495:
496: hr_utility_trace('Creating magtape assignment action '||

Line 720: ,pay_assignment_actions paa

716: ,ltrim(rtrim(PATERNAL_LAST_NAME)) ||' '
717: ||ltrim(rtrim(MATERNAL_LAST_NAME)) ||' '
718: ||ltrim(rtrim(NAMES)) FULL_NAME
719: FROM pay_mx_isr_tax_format37_v dim
720: ,pay_assignment_actions paa
721: ,pay_action_interlocks pai
722: WHERE dim.payroll_action_id = paa.payroll_action_id
723: AND dim.person_id = to_number(paa.serial_number)
724: AND paa.assignment_action_id = pai.locked_action_id