[Home] [Help]
236: IS
237: CURSOR c_payroll_Action_info (cp_payroll_action_id IN NUMBER) IS
238: SELECT effective_date,
239: business_group_id,
240: pay_mx_utility.get_legi_param_val( 'LEGAL_EMPLOYER'
241: ,legislative_parameters)
242: FROM pay_payroll_actions
243: WHERE payroll_action_id = cp_payroll_action_id;
244:
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''
325: AND ppa_arch.report_category = ''ARCHIVE''
326: AND pay_mx_utility.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',
327: ppa_arch.legislative_parameters) = '||gn_legal_er_id||'
328: AND TRUNC(ppa_arch.effective_date,''Y'') =
329: fnd_date.canonical_to_date('''||
330: fnd_date.date_to_canonical(gd_effective_date)||''')
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'
366: AND ppa_arch.report_category = 'ARCHIVE'
367: AND pay_mx_utility.get_parameter('TRANSFER_LEGAL_EMPLOYER',
368: ppa_arch.legislative_parameters) = cp_legal_er_id
369: AND TRUNC(ppa_arch.effective_date,'Y') = TRUNC(cp_effective_date,'Y')
370: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id
371: AND paa_arch.action_status = 'C'
389: WHERE ppa_arch.business_group_id = cp_business_group_id
390: AND ppa_arch.report_type = 'MX_YREND_ARCHIVE'
391: AND ppa_arch.report_qualifier = 'MX'
392: AND ppa_arch.report_category = 'ARCHIVE'
393: AND pay_mx_utility.get_parameter('TRANSFER_LEGAL_EMPLOYER',
394: ppa_arch.legislative_parameters) = cp_legal_er_id
395: AND TRUNC(ppa_arch.effective_date,'Y') = TRUNC(cp_effective_date,'Y')
396: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id
397: AND paa_arch.action_status = 'C'