APPS.PAY_MX_DIM_MAG dependencies on PAY_PAYROLL_ACTIONS

Line 242: FROM pay_payroll_actions

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:
245: ld_end_date DATE;
246: ln_business_group_id NUMBER;

Line 321: ,pay_payroll_actions ppa_arch

317:
318: p_sqlstr := '
319: SELECT DISTINCT to_number(paa_arch.serial_number)
320: FROM pay_assignment_actions paa_arch
321: ,pay_payroll_actions ppa_arch
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''

Line 362: pay_payroll_actions ppa_arch

358: ,paa_arch.assignment_id
359: ,paa_arch.serial_number person_id
360: ,ppa_arch.payroll_action_id
361: FROM pay_assignment_actions paa_arch,
362: pay_payroll_actions ppa_arch
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'

Line 387: pay_payroll_actions ppa_arch,

383: ,paa_arch.assignment_id
384: ,paa_arch.serial_number person_id
385: ,ppa_arch.payroll_action_id
386: FROM pay_assignment_actions paa_arch,
387: pay_payroll_actions ppa_arch,
388: pay_population_ranges ppr
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'