APPS.PAY_MX_DIM_MAG dependencies on PAY_PAYROLL_ACTIONS

Line 248: FROM pay_payroll_actions

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:
251: ld_end_date DATE;
252: ln_business_group_id NUMBER;

Line 327: ,pay_payroll_actions ppa_arch

323:
324: p_sqlstr := '
325: SELECT DISTINCT to_number(paa_arch.serial_number)
326: FROM pay_assignment_actions paa_arch
327: ,pay_payroll_actions ppa_arch
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''

Line 368: pay_payroll_actions ppa_arch

364: ,paa_arch.assignment_id
365: ,paa_arch.serial_number person_id
366: ,ppa_arch.payroll_action_id
367: FROM pay_assignment_actions paa_arch,
368: pay_payroll_actions ppa_arch
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'

Line 393: pay_payroll_actions ppa_arch,

389: ,paa_arch.assignment_id
390: ,paa_arch.serial_number person_id
391: ,ppa_arch.payroll_action_id
392: FROM pay_assignment_actions paa_arch,
393: pay_payroll_actions ppa_arch,
394: pay_population_ranges ppr
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'