APPS.PQP_GB_PSI_FUNCTIONS dependencies on PER_ASSIGNMENT_STATUS_TYPES
Line 226: FROM per_assignment_status_types
222: )
223: IS
224: SELECT DECODE(pay_system_status,'D','DO NOT PROCESS','P','PROCESS')
225: ,per_system_status 226: FROM per_assignment_status_types 227: WHERE ASSIGNMENT_STATUS_TYPE_ID = p_assignment_status_type_id
228: AND primary_flag = 'P';
229:
230: -- cursor to check if the change is on FTE