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 5429: FROM per_assignment_status_types

5425: )
5426: IS
5427: SELECT DECODE(pay_system_status,'D','DO NOT PROCESS','P','PROCESS')
5428: ,per_system_status
5429: FROM per_assignment_status_types
5430: WHERE ASSIGNMENT_STATUS_TYPE_ID = p_assignment_status_type_id
5431: AND primary_flag = 'P';
5432:
5433: l_asg_details csr_asg_details_up%ROWTYPE;

Line 5534: l_per_assg_status per_assignment_status_types.per_system_status%TYPE;

5530: l_return BOOLEAN;
5531: l_include VARCHAR2(10) := 'Y';
5532: l_assignment_status_type_id NUMBER;
5533: l_pay_assg_status VARCHAR2(20);
5534: l_per_assg_status per_assignment_status_types.per_system_status%TYPE;
5535: l_curr_person_dtls per_all_people_f%ROWTYPE;
5536: -- this contains the person details on effective date
5537:
5538: l_curr_assg_dtls per_all_assignments_f%ROWTYPE;

Line 5547: FROM per_assignment_status_types

5543: )
5544: IS
5545: SELECT DECODE(pay_system_status,'D','DO NOT PROCESS','P','PROCESS')
5546: ,per_system_status
5547: FROM per_assignment_status_types
5548: WHERE ASSIGNMENT_STATUS_TYPE_ID = p_assignment_status_type_id
5549: AND primary_flag = 'P';
5550:
5551: BEGIN -- is_future_claim