[Home] [Help]
327: hr_utility_trace ('gv_sort_opt = '|| gv_sort_opt);
328:
329: p_sqlstr := '
330: SELECT DISTINCT paa_arch.serial_number
331: FROM pay_assignment_actions paa_arch
332: ,pay_payroll_actions ppa_arch
333: WHERE ppa_arch.business_group_id = '|| gn_business_group_id ||'
334: AND ppa_arch.report_type = ''MX_YREND_ARCHIVE''
335: AND ppa_arch.report_qualifier = ''MX''
368: SELECT paa_arch.assignment_action_id
369: ,paa_arch.assignment_id
370: ,paa_arch.serial_number person_id
371: ,ppa_arch.payroll_action_id
372: FROM pay_assignment_actions paa_arch,
373: pay_payroll_actions ppa_arch
374: WHERE ppa_arch.business_group_id = cp_business_group_id
375: AND ppa_arch.report_type = 'MX_YREND_ARCHIVE'
376: AND ppa_arch.report_qualifier = 'MX'
398: SELECT paa_arch.assignment_action_id
399: ,paa_arch.assignment_id
400: ,paa_arch.serial_number person_id
401: ,ppa_arch.payroll_action_id
402: FROM pay_assignment_actions paa_arch,
403: pay_payroll_actions ppa_arch,
404: pay_population_ranges ppr
405: WHERE ppa_arch.business_group_id = cp_business_group_id
406: AND ppa_arch.report_type = 'MX_YREND_ARCHIVE'
511: hr_utility_trace('Previous person = '||ln_prev_person_id);
512:
513: IF (ln_person_id <> ln_prev_person_id) THEN
514:
515: SELECT pay_assignment_actions_s.nextval
516: INTO ln_mag_asg_act_id
517: FROM dual;
518:
519: hr_utility_trace('Creating report assignment action '||
587: ,nvl( ISR_SUBSIDY_FOR_EMP,0) ISR_SUBSIDY_FOR_EMP
588: ,nvl(TOTAL_SUBJECT_EARNINGS,0)+
589: nvl(TOTAL_EXEMPT_EARNINGS,0) TOTAL_EARNINGS
590: FROM PAY_MX_ISR_TAX_FORMAT37_V subemp_rpt
591: ,pay_assignment_actions paa
592: ,pay_action_interlocks pai
593: ,per_periods_of_service pos
594: ,per_all_people_f ppf
595: ,per_all_assignments_f paf
608: AND NVL(pos.actual_termination_date, gd_end_date) > gd_start_date;
609:
610: CURSOR c_pact_id (cp_assignment_action_id NUMBER) IS
611: SELECT paa.payroll_action_id
612: FROM pay_assignment_actions paa
613: WHERE paa.assignment_action_id = cp_assignment_action_id;
614:
615:
616: