DBA Data[Home] [Help]

APPS.PQP_GB_PSI_ALLOWANCE_HISTORY dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 91: FROM per_assignment_status_types

87: )
88: IS
89: SELECT DECODE(pay_system_status,'D','DO NOT PROCESS','P','PROCESS')
90: ,per_system_status
91: FROM per_assignment_status_types
92: WHERE ASSIGNMENT_STATUS_TYPE_ID = p_assignment_status_type_id
93: AND primary_flag = 'P';
94:
95: TYPE t_number IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;