230: IS
231: CURSOR c_payroll_Action_info (cp_payroll_action_id IN NUMBER) IS
232: SELECT effective_date,
233: business_group_id,
234: pay_mx_utility.get_legi_param_val( 'LEGAL_EMPLOYER'
235: ,legislative_parameters)
236: FROM pay_payroll_actions
237: WHERE payroll_action_id = cp_payroll_action_id;
238:
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''
319: AND ppa_arch.report_category = ''ARCHIVE''
320: AND pay_mx_utility.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',
321: ppa_arch.legislative_parameters) = '||gn_legal_er_id||'
322: AND TRUNC(ppa_arch.effective_date,''Y'') =
323: fnd_date.canonical_to_date('''||
324: fnd_date.date_to_canonical(gd_effective_date)||''')
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'
360: AND ppa_arch.report_category = 'ARCHIVE'
361: AND pay_mx_utility.get_parameter('TRANSFER_LEGAL_EMPLOYER',
362: ppa_arch.legislative_parameters) = cp_legal_er_id
363: AND TRUNC(ppa_arch.effective_date,'Y') = TRUNC(cp_effective_date,'Y')
364: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id
365: AND paa_arch.action_status = 'C'
383: WHERE ppa_arch.business_group_id = cp_business_group_id
384: AND ppa_arch.report_type = 'MX_YREND_ARCHIVE'
385: AND ppa_arch.report_qualifier = 'MX'
386: AND ppa_arch.report_category = 'ARCHIVE'
387: AND pay_mx_utility.get_parameter('TRANSFER_LEGAL_EMPLOYER',
388: ppa_arch.legislative_parameters) = cp_legal_er_id
389: AND TRUNC(ppa_arch.effective_date,'Y') = TRUNC(cp_effective_date,'Y')
390: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id
391: AND paa_arch.action_status = 'C'