APPS.PQP_GB_PSI_SALARY_HISTORY dependencies on PER_ASSIGNMENT_STATUS_TYPES
Line 61: FROM per_assignment_status_types
57: )
58: IS
59: SELECT DECODE(pay_system_status,'D','DO NOT PROCESS','P','PROCESS')
60: ,per_system_status 61: FROM per_assignment_status_types 62: WHERE ASSIGNMENT_STATUS_TYPE_ID = p_assignment_status_type_id
63: AND primary_flag = 'P';
64:
65: TYPE t_number IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;