DBA Data[Home] [Help]

APPS.PQH_GSP_UTILITY dependencies on PER_ASSIGNMENT_STATUS_TYPES_TL

Line 4240: From PER_ASSIGNMENT_STATUS_TYPES_TL

4236: Return varchar2 Is
4237:
4238: Cursor Csr_Assgt_status is
4239: Select User_Status
4240: From PER_ASSIGNMENT_STATUS_TYPES_TL
4241: where Assignment_Status_Type_Id = P_Assgt_Status_Id
4242: and language = userenv('LANG');
4243:
4244: L_User_Status PER_ASSIGNMENT_STATUS_TYPES_TL.User_Status%TYPE;

Line 4244: L_User_Status PER_ASSIGNMENT_STATUS_TYPES_TL.User_Status%TYPE;

4240: From PER_ASSIGNMENT_STATUS_TYPES_TL
4241: where Assignment_Status_Type_Id = P_Assgt_Status_Id
4242: and language = userenv('LANG');
4243:
4244: L_User_Status PER_ASSIGNMENT_STATUS_TYPES_TL.User_Status%TYPE;
4245: begin
4246:
4247: If P_Assgt_Status_Id is NOT NULL then
4248: Open Csr_Assgt_Status;