DBA Data[Home] [Help]

APPS.PQH_GSP_UTILITY dependencies on PER_ASSIGNMENT_STATUS_TYPES_TL

Line 4359: From PER_ASSIGNMENT_STATUS_TYPES_TL

4355: Return varchar2 Is
4356:
4357: Cursor Csr_Assgt_status is
4358: Select User_Status
4359: From PER_ASSIGNMENT_STATUS_TYPES_TL
4360: where Assignment_Status_Type_Id = P_Assgt_Status_Id
4361: and language = userenv('LANG');
4362:
4363: L_User_Status PER_ASSIGNMENT_STATUS_TYPES_TL.User_Status%TYPE;

Line 4363: L_User_Status PER_ASSIGNMENT_STATUS_TYPES_TL.User_Status%TYPE;

4359: From PER_ASSIGNMENT_STATUS_TYPES_TL
4360: where Assignment_Status_Type_Id = P_Assgt_Status_Id
4361: and language = userenv('LANG');
4362:
4363: L_User_Status PER_ASSIGNMENT_STATUS_TYPES_TL.User_Status%TYPE;
4364: begin
4365:
4366: If P_Assgt_Status_Id is NOT NULL then
4367: Open Csr_Assgt_Status;