APPS.PQH_SS_PRINT dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 910: from per_assignment_status_types asg,

906: FUNCTION get_user_status(p_assignment_status_type_id IN NUMBER) RETURN VARCHAR2
907: IS
908: CURSOR csr_user_status IS
909: select tl.user_status
910: from per_assignment_status_types asg,
911: per_assignment_status_types_tl tl
912: where asg.assignment_status_type_id = p_assignment_status_type_id
913: and asg.assignment_status_type_id = tl.assignment_status_type_id
914: and tl.language=USERENV('LANG');

Line 911: per_assignment_status_types_tl tl

907: IS
908: CURSOR csr_user_status IS
909: select tl.user_status
910: from per_assignment_status_types asg,
911: per_assignment_status_types_tl tl
912: where asg.assignment_status_type_id = p_assignment_status_type_id
913: and asg.assignment_status_type_id = tl.assignment_status_type_id
914: and tl.language=USERENV('LANG');
915: --

Line 916: l_user_status per_assignment_status_types_tl.user_status%type :=null;

912: where asg.assignment_status_type_id = p_assignment_status_type_id
913: and asg.assignment_status_type_id = tl.assignment_status_type_id
914: and tl.language=USERENV('LANG');
915: --
916: l_user_status per_assignment_status_types_tl.user_status%type :=null;
917: --
918: BEGIN
919:
920: open csr_user_status ;