APPS.PAY_MX_PTU_CALC dependencies on PAY_ASSIGNMENT_ACTIONS

Line 307: FROM pay_assignment_actions paa,

303: IF ln_asg_set_id IS NULL THEN
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(''' ||

Line 327: FROM pay_assignment_actions paa,

323: ORDER BY paf.person_id';
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(''' ||

Line 452: pay_assignment_actions paa,

448: NVL(paf.employment_category, 'MX1_PERM_WRK'),
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

Line 488: FROM pay_assignment_actions paa,

484: paf_pri.assignment_id,
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

Line 977: SELECT pay_assignment_actions_s.NEXTVAL

973: END IF;
974:
975: lb_valid_pri_asg_found := TRUE;
976:
977: SELECT pay_assignment_actions_s.NEXTVAL
978: INTO ln_PTU_action_id
979: FROM dual;
980:
981: hr_nonrun_asact.insact(ln_PTU_action_id,