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

Line 249: per_assignments_f paaf,

245: cursor c_pay_basis is
246: select hl.meaning pay_basis
247: from hr_organization_units hou,
248: hr_soft_coding_keyflex hsc,
249: per_assignments_f paaf,
250: per_pay_bases ppb,
251: hr_lookups hl
252: where to_char(hou.organization_id) = hsc.segment1
253: and hsc.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id

Line 456: from per_assignments_f paf,

452: v_dummy number(1);
453: --cursor latest_le(organization_id,date_start,actual_termination_date) s
454: cursor latest_le(organization_id varchar2,date_start date,actual_termination_date date) is
455: select 1
456: from per_assignments_f paf,
457: hr_soft_coding_keyflex hsc
458: --where paf.person_id = p_person_id
459: where paf.person_id = lp_person_id
460: and paf.business_group_id = lp_business_group_id

Line 466: from per_assignments_f paf1,

462: and hsc.segment1 = organization_id
463: and paf.primary_flag = 'Y'
464: and paf.effective_start_date =
465: (select max(paf1.effective_start_date)
466: from per_assignments_f paf1,
467: per_assignment_status_types past
468: where paf1.person_id = paf.person_id
469: and paf1.assignment_status_type_id = past.assignment_status_type_id
470: and past.per_system_status = 'ACTIVE_ASSIGN'