eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_MX_PTU_CALC dependencies on PAY_PAYROLL_ACTIONS

Line 45: FROM pay_payroll_actions

41: pay_mx_utility.get_parameter('LEGAL_EMPLOYER',
42: legislative_parameters) LEGAL_EMPLOYER,
43: pay_mx_utility.get_parameter('ASG_SET_ID',
44: legislative_parameters) ASG_SET_ID
45: FROM pay_payroll_actions
46: WHERE payroll_action_id = cp_payroll_action_id;
47:
48: ld_start_date DATE;
49: ld_effective_date DATE;

Line 314: pay_payroll_actions ppa,

310:
311: lv_sql_string :=
312: 'SELECT DISTINCT paf.person_id
313: FROM pay_assignment_actions paa,
314: pay_payroll_actions ppa,
315: per_assignments_f paf
316: WHERE ppa.business_group_id = ' || ln_business_group_id || '
317: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
318: fnd_date.date_to_canonical(ld_start_date) || ''')

Line 334: pay_payroll_actions ppa,

330: ELSE
331: lv_sql_string :=
332: 'SELECT DISTINCT paf.person_id
333: FROM pay_assignment_actions paa,
334: pay_payroll_actions ppa,
335: per_assignments_f paf
336: WHERE ppa.business_group_id = ' || ln_business_group_id || '
337: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
338: fnd_date.date_to_canonical(ld_start_date) || ''')

Line 459: pay_payroll_actions ppa,

455: paa.tax_unit_id
456: FROM per_assignments_f paf,
457: per_assignments_f paf_pri,
458: pay_assignment_actions paa,
459: pay_payroll_actions ppa,
460: pay_population_ranges ppr
461: WHERE ppa.business_group_id = cp_bg_id
462: AND paf.assignment_id = paa.assignment_id
463: AND pay_mx_yrend_arch.gre_exists(paa.tax_unit_id) = 1

Line 496: pay_payroll_actions ppa,

492: paf_pri.person_id,
493: NVL(paf.employment_category, 'MX1_PERM_WRK'),
494: paa.tax_unit_id
495: FROM pay_assignment_actions paa,
496: pay_payroll_actions ppa,
497: per_assignments_f paf,
498: per_assignments_f paf_pri
499: WHERE ppa.business_group_id = cp_bg_id
500: AND ppa.effective_date BETWEEN cp_start_date

Line 1211: pay_payroll_actions ppa

1207: IS
1208: SELECT DISTINCT paf.person_id
1209: FROM pay_temp_object_actions ptoa,
1210: per_assignments_f paf,
1211: pay_payroll_actions ppa
1212: WHERE ptoa.payroll_action_id = p_payroll_action_id
1213: AND paf.assignment_id = ptoa.object_id
1214: AND ptoa.object_type = 'ASG'
1215: AND ppa.payroll_action_id = ptoa.payroll_action_id

Line 1522: pay_payroll_actions ppa

1518: paf.business_group_id,
1519: ptoa.payroll_action_id
1520: FROM pay_temp_object_actions ptoa,
1521: per_assignments_f paf,
1522: pay_payroll_actions ppa
1523: WHERE ptoa.object_action_id = p_archive_action_id
1524: AND paf.assignment_id = ptoa.object_id
1525: AND ptoa.object_type = 'ASG'
1526: AND ppa.payroll_action_id = ptoa.payroll_action_id