[Home] [Help]
309: IF ln_asg_set_id IS NULL THEN
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(''' ||
329: ORDER BY paf.person_id';
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(''' ||
454: NVL(paf.employment_category, 'MX1_PERM_WRK'),
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
491: paf_pri.assignment_id,
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
1008: END IF;
1009:
1010: lb_valid_pri_asg_found := TRUE;
1011:
1012: SELECT pay_assignment_actions_s.NEXTVAL
1013: INTO ln_PTU_action_id
1014: FROM dual;
1015:
1016: hr_nonrun_asact.insact(ln_PTU_action_id,