APPS.PAY_MX_SUBSIDY_EMP_PD_RPT dependencies on PAY_MX_UTILITY

Line 206: pay_mx_utility.get_legi_param_val( 'LEGAL_EMPLOYER'

202: IS
203: CURSOR c_payroll_Action_info (cp_payroll_action_id IN NUMBER) IS
204: SELECT effective_date,
205: business_group_id,
206: pay_mx_utility.get_legi_param_val( 'LEGAL_EMPLOYER'
207: ,legislative_parameters),
208: pay_mx_utility.get_legi_param_val( 'SORT_OPT'
209: ,legislative_parameters) ,
210: pay_mx_utility.get_legi_param_val( 'ASS_SET'

Line 208: pay_mx_utility.get_legi_param_val( 'SORT_OPT'

204: SELECT effective_date,
205: business_group_id,
206: pay_mx_utility.get_legi_param_val( 'LEGAL_EMPLOYER'
207: ,legislative_parameters),
208: pay_mx_utility.get_legi_param_val( 'SORT_OPT'
209: ,legislative_parameters) ,
210: pay_mx_utility.get_legi_param_val( 'ASS_SET'
211: ,legislative_parameters)
212: , pay_mx_utility.get_legi_param_val( 'RPT_YEAR'

Line 210: pay_mx_utility.get_legi_param_val( 'ASS_SET'

206: pay_mx_utility.get_legi_param_val( 'LEGAL_EMPLOYER'
207: ,legislative_parameters),
208: pay_mx_utility.get_legi_param_val( 'SORT_OPT'
209: ,legislative_parameters) ,
210: pay_mx_utility.get_legi_param_val( 'ASS_SET'
211: ,legislative_parameters)
212: , pay_mx_utility.get_legi_param_val( 'RPT_YEAR'
213: ,legislative_parameters)
214: , pay_mx_utility.get_legi_param_val( 'START_DATE'

Line 212: , pay_mx_utility.get_legi_param_val( 'RPT_YEAR'

208: pay_mx_utility.get_legi_param_val( 'SORT_OPT'
209: ,legislative_parameters) ,
210: pay_mx_utility.get_legi_param_val( 'ASS_SET'
211: ,legislative_parameters)
212: , pay_mx_utility.get_legi_param_val( 'RPT_YEAR'
213: ,legislative_parameters)
214: , pay_mx_utility.get_legi_param_val( 'START_DATE'
215: ,legislative_parameters)
216: ,pay_mx_utility.get_legi_param_val( 'END_DATE'

Line 214: , pay_mx_utility.get_legi_param_val( 'START_DATE'

210: pay_mx_utility.get_legi_param_val( 'ASS_SET'
211: ,legislative_parameters)
212: , pay_mx_utility.get_legi_param_val( 'RPT_YEAR'
213: ,legislative_parameters)
214: , pay_mx_utility.get_legi_param_val( 'START_DATE'
215: ,legislative_parameters)
216: ,pay_mx_utility.get_legi_param_val( 'END_DATE'
217: ,legislative_parameters)
218:

Line 216: ,pay_mx_utility.get_legi_param_val( 'END_DATE'

212: , pay_mx_utility.get_legi_param_val( 'RPT_YEAR'
213: ,legislative_parameters)
214: , pay_mx_utility.get_legi_param_val( 'START_DATE'
215: ,legislative_parameters)
216: ,pay_mx_utility.get_legi_param_val( 'END_DATE'
217: ,legislative_parameters)
218:
219: FROM pay_payroll_actions
220: WHERE payroll_action_id = cp_payroll_action_id;

Line 337: AND pay_mx_utility.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',

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''
336: AND ppa_arch.report_category = ''ARCHIVE''
337: AND pay_mx_utility.get_parameter(''TRANSFER_LEGAL_EMPLOYER'',
338: ppa_arch.legislative_parameters) = '||gn_legal_er_id||'
339: AND TRUNC(ppa_arch.effective_date,''Y'') =
340: fnd_date.canonical_to_date('''||
341: fnd_date.date_to_canonical(gd_effective_date)||''')

Line 378: AND pay_mx_utility.get_parameter('TRANSFER_LEGAL_EMPLOYER',

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'
377: AND ppa_arch.report_category = 'ARCHIVE'
378: AND pay_mx_utility.get_parameter('TRANSFER_LEGAL_EMPLOYER',
379: ppa_arch.legislative_parameters) = cp_legal_er_id
380: AND TRUNC(ppa_arch.effective_date,'Y') = TRUNC(cp_effective_date,'Y')
381: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id
382: AND paa_arch.action_status = 'C'

Line 409: AND pay_mx_utility.get_parameter('TRANSFER_LEGAL_EMPLOYER',

405: WHERE ppa_arch.business_group_id = cp_business_group_id
406: AND ppa_arch.report_type = 'MX_YREND_ARCHIVE'
407: AND ppa_arch.report_qualifier = 'MX'
408: AND ppa_arch.report_category = 'ARCHIVE'
409: AND pay_mx_utility.get_parameter('TRANSFER_LEGAL_EMPLOYER',
410: ppa_arch.legislative_parameters) = cp_legal_er_id
411: AND TRUNC(ppa_arch.effective_date,'Y') = TRUNC(cp_effective_date,'Y')
412: AND paa_arch.payroll_action_id = ppa_arch.payroll_action_id
413: AND paa_arch.action_status = 'C'