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

Line 877: , per_assignments_f paf

873: SELECT DISTINCT(DECODE(pcr.contact_type,'JP_FT','Father','F','Father','S','Spouse')) relation_type
874: , ppf.sex sex
875: , ppf.marital_status marital_status
876: FROM per_people_f ppf
877: , per_assignments_f paf
878: , per_contact_relationships pcr
879: WHERE paf.assignment_id = p_assignment_id
880: AND paf.person_id = ppf.person_id
881: AND pcr.person_id = ppf.person_id

Line 1587: FROM per_assignments_f paf

1583: IS
1584: SELECT hsc.segment2
1585: ,hsc.segment3
1586: ,hsc.segment4
1587: FROM per_assignments_f paf
1588: ,hr_soft_coding_keyflex hsc
1589: WHERE paf.assignment_id = p_assignment_id
1590: AND paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
1591: AND paf.business_group_id = p_business_group_id