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_NL_EOY_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 48: ,per_assignment_status_types pas

44: CURSOR get_dates(p_assignment_id NUMBER) IS
45: select min(paa.effective_start_date)
46: ,max(paa.effective_end_date)
47: from per_all_assignments_f paa
48: ,per_assignment_status_types pas
49: where assignment_id=p_assignment_id
50: and paa.assignment_status_type_id=pas.assignment_status_type_id
51: and pas.PER_SYSTEM_STATUS='ACTIVE_ASSIGN';
52:

Line 990: , per_assignment_status_types ast

986: , scl.segment12 last_year_sal
987: , ast.user_status
988: from per_all_assignments_f asg
989: ,hr_soft_coding_keyflex scl
990: , per_assignment_status_types ast
991: where organization_id in
992: (select pose.organization_id_child
993: from per_org_structure_elements pose,per_org_structure_versions posv
994: where

Line 1120: ,per_assignment_status_types pas

1116: ,paa.object_version_number
1117: ,hsck.segment12
1118: from per_all_assignments_f paa
1119: ,hr_soft_coding_keyflex hsck
1120: ,per_assignment_status_types pas
1121: where person_id=p_person_id
1122: and paa.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id (+)
1123: and pas.assignment_status_type_id=paa.assignment_status_type_id
1124: and pas.PER_SYSTEM_STATUS='ACTIVE_ASSIGN'