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 PER_ASSIGNMENTS_F

Line 315: per_assignments_f paf

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) || ''')
319: AND fnd_date.canonical_to_date(''' ||

Line 335: per_assignments_f paf

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) || ''')
339: AND fnd_date.canonical_to_date(''' ||

Line 357: per_assignments_f paf_all

353: OR EXISTS
354: (SELECT ''x''
355: FROM hr_assignment_sets has,
356: hr_assignment_set_amendments hasa,
357: per_assignments_f paf_all
358: WHERE has.assignment_set_id = ' || ln_asg_set_id || '
359: AND has.assignment_set_id = hasa.assignment_set_id
360: AND hasa.assignment_id = paf_all.assignment_id
361: AND paf_all.person_id = paf.person_id

Line 368: per_assignments_f paf_all

364: AND NOT EXISTS
365: (SELECT ''x''
366: FROM hr_assignment_sets has,
367: hr_assignment_set_amendments hasa,
368: per_assignments_f paf_all
369: WHERE has.assignment_set_id = ' || ln_asg_set_id || '
370: AND has.assignment_set_id = hasa.assignment_set_id
371: AND hasa.assignment_id = paf_all.assignment_id
372: AND paf_all.person_id = paf.person_id

Line 430: per_assignments_f paf_all

426: AND NOT EXISTS
427: (SELECT 'x'
428: FROM hr_assignment_sets has,
429: hr_assignment_set_amendments hasa,
430: per_assignments_f paf_all
431: WHERE has.assignment_set_id = cp_asg_set_id
432: AND has.assignment_set_id = hasa.assignment_set_id
433: AND hasa.assignment_id = paf_all.assignment_id
434: AND paf_all.person_id = cp_person_id

Line 440: per_assignments_f paf_all

436: )
437: OR EXISTS (SELECT 'x'
438: FROM hr_assignment_sets has,
439: hr_assignment_set_amendments hasa,
440: per_assignments_f paf_all
441: WHERE has.assignment_set_id = cp_asg_set_id
442: AND has.assignment_set_id = hasa.assignment_set_id
443: AND hasa.assignment_id = paf_all.assignment_id
444: AND paf_all.person_id = cp_person_id

Line 456: FROM per_assignments_f paf,

452: paf_pri.assignment_id,
453: paf_pri.person_id,
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

Line 457: per_assignments_f paf_pri,

453: paf_pri.person_id,
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

Line 497: per_assignments_f paf,

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
501: AND cp_end_date

Line 498: per_assignments_f paf_pri

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
501: AND cp_end_date
502: AND ppa.action_type IN ('Q','R','B','V','I')

Line 541: FROM per_assignments_f

537: ) IS
538: SELECT 'X'
539: FROM dual
540: WHERE NOT EXISTS(SELECT 'Y'
541: FROM per_assignments_f
542: WHERE assignment_id = cp_assignment_id
543: AND effective_start_date <= cp_end_date
544: AND effective_end_date >= cp_start_date);
545:

Line 1210: per_assignments_f paf,

1206: CURSOR c_get_elig_persons
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'

Line 1484: lv_assignment_number per_assignments_f.assignment_number%TYPE;

1480:
1481: ln_batch_line_id NUMBER;
1482: ln_ovn NUMBER;
1483: ln_assignment_id NUMBER;
1484: lv_assignment_number per_assignments_f.assignment_number%TYPE;
1485: ln_person_id NUMBER;
1486:
1487: ln_factor_B NUMBER:=0;
1488: ln_factor_C NUMBER:=0;

Line 1521: per_assignments_f paf,

1517: paf.person_id,
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'