APPS.PAY_MX_PTU_CALC dependencies on PAY_PAYROLL_ACTIONS

Line 43: FROM pay_payroll_actions

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

Line 308: pay_payroll_actions ppa,

304:
305: lv_sql_string :=
306: 'SELECT DISTINCT paf.person_id
307: FROM pay_assignment_actions paa,
308: pay_payroll_actions ppa,
309: per_assignments_f paf
310: WHERE ppa.business_group_id = ' || ln_business_group_id || '
311: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
312: fnd_date.date_to_canonical(ld_start_date) || ''')

Line 328: pay_payroll_actions ppa,

324: ELSE
325: lv_sql_string :=
326: 'SELECT DISTINCT paf.person_id
327: FROM pay_assignment_actions paa,
328: pay_payroll_actions ppa,
329: per_assignments_f paf
330: WHERE ppa.business_group_id = ' || ln_business_group_id || '
331: AND ppa.effective_date BETWEEN fnd_date.canonical_to_date(''' ||
332: fnd_date.date_to_canonical(ld_start_date) || ''')

Line 453: pay_payroll_actions ppa,

449: paa.tax_unit_id
450: FROM per_assignments_f paf,
451: per_assignments_f paf_pri,
452: pay_assignment_actions paa,
453: pay_payroll_actions ppa,
454: pay_population_ranges ppr
455: WHERE ppa.business_group_id = cp_bg_id
456: AND paf.assignment_id = paa.assignment_id
457: AND pay_mx_yrend_arch.gre_exists(paa.tax_unit_id) = 1

Line 489: pay_payroll_actions ppa,

485: paf_pri.person_id,
486: NVL(paf.employment_category, 'MX1_PERM_WRK'),
487: paa.tax_unit_id
488: FROM pay_assignment_actions paa,
489: pay_payroll_actions ppa,
490: per_assignments_f paf,
491: per_assignments_f paf_pri
492: WHERE ppa.business_group_id = cp_bg_id
493: AND ppa.effective_date BETWEEN cp_start_date

Line 1174: pay_payroll_actions ppa

1170: IS
1171: SELECT DISTINCT paf.person_id
1172: FROM pay_temp_object_actions ptoa,
1173: per_assignments_f paf,
1174: pay_payroll_actions ppa
1175: WHERE ptoa.payroll_action_id = p_payroll_action_id
1176: AND paf.assignment_id = ptoa.object_id
1177: AND ptoa.object_type = 'ASG'
1178: AND ppa.payroll_action_id = ptoa.payroll_action_id

Line 1484: pay_payroll_actions ppa

1480: paf.business_group_id,
1481: ptoa.payroll_action_id
1482: FROM pay_temp_object_actions ptoa,
1483: per_assignments_f paf,
1484: pay_payroll_actions ppa
1485: WHERE ptoa.object_action_id = p_archive_action_id
1486: AND paf.assignment_id = ptoa.object_id
1487: AND ptoa.object_type = 'ASG'
1488: AND ppa.payroll_action_id = ptoa.payroll_action_id