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_CA_RL1_REG dependencies on PER_ASSIGNMENTS_F

Line 414: per_assignments_f paf

410: and ppa.payroll_action_id = paa.payroll_action_id
411: and to_number(paa.serial_number) between stperson and endperson
412: and exists (select 1
413: from hr_assignment_set_amendments hasa,
414: per_assignments_f paf
415: where hasa.assignment_set_id = l_asg_set_id
416: and upper(hasa.include_or_exclude) = 'I'
417: and hasa.assignment_id = paf.assignment_id
418: and paf.person_id = to_number(paa.serial_number))

Line 446: per_assignments_f paf

442: and ppr.chunk_number = chunk
443: and ppr.person_id = to_number(paa.serial_number)
444: and exists (select 1
445: from hr_assignment_set_amendments hasa,
446: per_assignments_f paf
447: where hasa.assignment_set_id = l_asg_set_id
448: and upper(hasa.include_or_exclude) = 'I'
449: and hasa.assignment_id = paf.assignment_id
450: and paf.person_id = to_number(paa.serial_number))

Line 456: from per_assignments_f paf

452:
453: cursor c_get_asg_id (p_person_id number) is
454: select paf.assignment_id,
455: paf.effective_end_date
456: from per_assignments_f paf
457: where person_id = p_person_id
458: and primary_flag = 'Y'
459: and assignment_type = 'E'
460: and paf.effective_start_date <= l_year_end

Line 468: from per_assignments_f paf,

464: --Changes for bug 15886428 starts
465: cursor c_get_asg_id_term (p_person_id number) is
466: select paf.assignment_id,
467: paf.effective_end_date
468: from per_assignments_f paf,
469: per_periods_of_service pds
470: where paf.person_id = p_person_id
471: and paf.primary_flag = 'Y'
472: and paf.assignment_type = 'E'