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.PQP_GB_PSI_FUNCTIONS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 5319: FROM per_assignment_status_types

5315: )
5316: IS
5317: SELECT DECODE(pay_system_status,'D','DO NOT PROCESS','P','PROCESS')
5318: ,per_system_status
5319: FROM per_assignment_status_types
5320: WHERE ASSIGNMENT_STATUS_TYPE_ID = p_assignment_status_type_id
5321: AND primary_flag = 'P';
5322:
5323: l_asg_details csr_asg_details_up%ROWTYPE;

Line 5424: l_per_assg_status per_assignment_status_types.per_system_status%TYPE;

5420: l_return BOOLEAN;
5421: l_include VARCHAR2(10) := 'Y';
5422: l_assignment_status_type_id NUMBER;
5423: l_pay_assg_status VARCHAR2(20);
5424: l_per_assg_status per_assignment_status_types.per_system_status%TYPE;
5425: l_curr_person_dtls per_all_people_f%ROWTYPE;
5426: -- this contains the person details on effective date
5427:
5428: l_curr_assg_dtls per_all_assignments_f%ROWTYPE;

Line 5437: FROM per_assignment_status_types

5433: )
5434: IS
5435: SELECT DECODE(pay_system_status,'D','DO NOT PROCESS','P','PROCESS')
5436: ,per_system_status
5437: FROM per_assignment_status_types
5438: WHERE ASSIGNMENT_STATUS_TYPE_ID = p_assignment_status_type_id
5439: AND primary_flag = 'P';
5440:
5441: BEGIN -- is_future_claim