APPS.PAY_MX_SUBSIDY_EMP_PD_RPT dependencies on PAY_PAYROLL_ACTIONS

Line 219: FROM pay_payroll_actions

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;
221:
222:
223: CURSOR c_ass_set_name (cp_ass_set_id NUMBER) IS

Line 332: ,pay_payroll_actions ppa_arch

328:
329: p_sqlstr := '
330: SELECT DISTINCT paa_arch.serial_number
331: FROM pay_assignment_actions paa_arch
332: ,pay_payroll_actions ppa_arch
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''

Line 373: pay_payroll_actions ppa_arch

369: ,paa_arch.assignment_id
370: ,paa_arch.serial_number person_id
371: ,ppa_arch.payroll_action_id
372: FROM pay_assignment_actions paa_arch,
373: pay_payroll_actions ppa_arch
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'

Line 403: pay_payroll_actions ppa_arch,

399: ,paa_arch.assignment_id
400: ,paa_arch.serial_number person_id
401: ,ppa_arch.payroll_action_id
402: FROM pay_assignment_actions paa_arch,
403: pay_payroll_actions ppa_arch,
404: pay_population_ranges ppr
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'