APPS.PAY_MX_FORMAT_2D dependencies on PAY_PAYROLL_ACTIONS

Line 236: FROM pay_payroll_actions

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:
239: ld_end_date DATE;
240: ln_business_group_id NUMBER;

Line 315: ,pay_payroll_actions ppa_arch

311:
312: p_sqlstr := '
313: SELECT DISTINCT paa_arch.serial_number
314: FROM pay_assignment_actions paa_arch
315: ,pay_payroll_actions ppa_arch
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''

Line 356: pay_payroll_actions ppa_arch

352: ,paa_arch.assignment_id
353: ,paa_arch.serial_number person_id
354: ,ppa_arch.payroll_action_id
355: FROM pay_assignment_actions paa_arch,
356: pay_payroll_actions ppa_arch
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'

Line 381: pay_payroll_actions ppa_arch,

377: ,paa_arch.assignment_id
378: ,paa_arch.serial_number person_id
379: ,ppa_arch.payroll_action_id
380: FROM pay_assignment_actions paa_arch,
381: pay_payroll_actions ppa_arch,
382: pay_population_ranges ppr
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'