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 HR_ASSIGNMENT_SET_AMENDMENTS

Line 350: FROM hr_assignment_set_amendments hasa

346: AND paf.effective_end_date
347: AND pay_mx_yrend_arch.gre_exists (paa.tax_unit_id) = 1
348: AND (NOT EXISTS
349: (SELECT ''x''
350: FROM hr_assignment_set_amendments hasa
351: WHERE hasa.assignment_set_id = ' || ln_asg_set_id || '
352: AND hasa.include_or_exclude = ''I'')
353: OR EXISTS
354: (SELECT ''x''

Line 356: hr_assignment_set_amendments hasa,

352: AND hasa.include_or_exclude = ''I'')
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

Line 367: hr_assignment_set_amendments hasa,

363: )
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

Line 423: FROM hr_assignment_set_amendments hasa

419: cp_person_id NUMBER) IS
420: SELECT 'X'
421: FROM dual
422: WHERE (EXISTS(SELECT 'x'
423: FROM hr_assignment_set_amendments hasa
424: WHERE hasa.assignment_set_id = cp_asg_set_id
425: AND hasa.include_or_exclude = 'I')
426: AND NOT EXISTS
427: (SELECT 'x'

Line 429: hr_assignment_set_amendments hasa,

425: AND hasa.include_or_exclude = 'I')
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

Line 439: hr_assignment_set_amendments hasa,

435: AND hasa.include_or_exclude = 'I')
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