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 55: ,per_assignment_status_types pas

51: CURSOR get_dates(p_assignment_id NUMBER) IS
52: select min(paa.effective_start_date)
53: ,max(paa.effective_end_date)
54: from per_all_assignments_f paa
55: ,per_assignment_status_types pas
56: where assignment_id=p_assignment_id
57: and paa.assignment_status_type_id=pas.assignment_status_type_id
58: and pas.PER_SYSTEM_STATUS='ACTIVE_ASSIGN'
59: and paa.PAYROLL_ID IS NOT NULL; --12576775

Line 1042: ,per_assignment_status_types ast

1038: , scl.segment12 last_year_sal
1039: -- , ast.user_status --12608988 Removed for performance optimization
1040: from per_all_assignments_f asg
1041: ,hr_soft_coding_keyflex scl
1042: ,per_assignment_status_types ast
1043: where organization_id in
1044: (select pose.organization_id_child
1045: from per_org_structure_elements pose,per_org_structure_versions posv
1046: where

Line 1263: ,per_assignment_status_types pas

1259: ,paa.object_version_number
1260: ,hsck.segment12
1261: from per_all_assignments_f paa
1262: ,hr_soft_coding_keyflex hsck
1263: ,per_assignment_status_types pas
1264: where person_id=p_person_id
1265: and paa.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id (+)
1266: and pas.assignment_status_type_id=paa.assignment_status_type_id
1267: and pas.PER_SYSTEM_STATUS='ACTIVE_ASSIGN'