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 309: per_assignments_f paf

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

Line 329: per_assignments_f paf

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

Line 351: per_assignments_f paf_all

347: OR EXISTS
348: (SELECT ''x''
349: FROM hr_assignment_sets has,
350: hr_assignment_set_amendments hasa,
351: per_assignments_f paf_all
352: WHERE has.assignment_set_id = ' || ln_asg_set_id || '
353: AND has.assignment_set_id = hasa.assignment_set_id
354: AND hasa.assignment_id = paf_all.assignment_id
355: AND paf_all.person_id = paf.person_id

Line 362: per_assignments_f paf_all

358: AND NOT EXISTS
359: (SELECT ''x''
360: FROM hr_assignment_sets has,
361: hr_assignment_set_amendments hasa,
362: per_assignments_f paf_all
363: WHERE has.assignment_set_id = ' || ln_asg_set_id || '
364: AND has.assignment_set_id = hasa.assignment_set_id
365: AND hasa.assignment_id = paf_all.assignment_id
366: AND paf_all.person_id = paf.person_id

Line 424: per_assignments_f paf_all

420: AND NOT EXISTS
421: (SELECT 'x'
422: FROM hr_assignment_sets has,
423: hr_assignment_set_amendments hasa,
424: per_assignments_f paf_all
425: WHERE has.assignment_set_id = cp_asg_set_id
426: AND has.assignment_set_id = hasa.assignment_set_id
427: AND hasa.assignment_id = paf_all.assignment_id
428: AND paf_all.person_id = cp_person_id

Line 434: per_assignments_f paf_all

430: )
431: OR EXISTS (SELECT 'x'
432: FROM hr_assignment_sets has,
433: hr_assignment_set_amendments hasa,
434: per_assignments_f paf_all
435: WHERE has.assignment_set_id = cp_asg_set_id
436: AND has.assignment_set_id = hasa.assignment_set_id
437: AND hasa.assignment_id = paf_all.assignment_id
438: AND paf_all.person_id = cp_person_id

Line 450: FROM per_assignments_f paf,

446: paf_pri.assignment_id,
447: paf_pri.person_id,
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

Line 451: per_assignments_f paf_pri,

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

Line 490: per_assignments_f paf,

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

Line 491: per_assignments_f paf_pri

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

Line 531: FROM per_assignments_f

527: ) IS
528: SELECT 'X'
529: FROM dual
530: WHERE NOT EXISTS(SELECT 'Y'
531: FROM per_assignments_f
532: WHERE assignment_id = cp_assignment_id
533: AND cp_effective_date BETWEEN effective_start_date
534: AND effective_end_date);
535:

Line 1173: per_assignments_f paf,

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

Line 1447: lv_assignment_number per_assignments_f.assignment_number%TYPE;

1443:
1444: ln_batch_line_id NUMBER;
1445: ln_ovn NUMBER;
1446: ln_assignment_id NUMBER;
1447: lv_assignment_number per_assignments_f.assignment_number%TYPE;
1448: ln_person_id NUMBER;
1449:
1450: ln_factor_B NUMBER;
1451: ln_factor_C NUMBER;

Line 1483: per_assignments_f paf,

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