[Home] [Help]
242: IS
243: CURSOR c_payroll_Action_info (cp_payroll_action_id IN NUMBER) IS
244: SELECT effective_date,
245: business_group_id,
246: pay_mx_utility.get_legi_param_val( 'LEGAL_EMPLOYER'
247: ,legislative_parameters)
248: FROM pay_payroll_actions
249: WHERE payroll_action_id = cp_payroll_action_id;
250:
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''
331: AND ppa_arch.report_category = ''ARCHIVE''
332: AND pay_mx_utility.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',
333: ppa_arch.legislative_parameters) = '||gn_legal_er_id||'
334: AND TRUNC(ppa_arch.effective_date,''Y'') =
335: fnd_date.canonical_to_date('''||
336: fnd_date.date_to_canonical(gd_effective_date)||''')
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'
372: AND ppa_arch.report_category = 'ARCHIVE'
373: AND pay_mx_utility.get_parameter('TRANSFER_LEGAL_EMPLOYER',
374: ppa_arch.legislative_parameters) = cp_legal_er_id
375: AND TRUNC(ppa_arch.effective_date,'Y') = TRUNC(cp_effective_date,'Y')
376: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id
377: AND paa_arch.action_status = 'C'
395: WHERE ppa_arch.business_group_id = cp_business_group_id
396: AND ppa_arch.report_type = 'MX_YREND_ARCHIVE'
397: AND ppa_arch.report_qualifier = 'MX'
398: AND ppa_arch.report_category = 'ARCHIVE'
399: AND pay_mx_utility.get_parameter('TRANSFER_LEGAL_EMPLOYER',
400: ppa_arch.legislative_parameters) = cp_legal_er_id
401: AND TRUNC(ppa_arch.effective_date,'Y') = TRUNC(cp_effective_date,'Y')
402: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id
403: AND paa_arch.action_status = 'C'