APPS.PQP_GB_PSI_HRS_HISTORY dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 146: p_per_system_status IN per_assignment_status_types.per_system_status%TYPE

142: -- ----------------------------------------------------------------------------
143: -- |----------------------< get_asg_status_type >-----------------------------|
144: -- ----------------------------------------------------------------------------
145: PROCEDURE get_asg_status_type(
146: p_per_system_status IN per_assignment_status_types.per_system_status%TYPE
147: ,p_rec_asg_sts_dtls OUT NOCOPY csr_get_asg_sts_dtls%ROWTYPE
148: )
149: IS
150: --

Line 206: RETURN per_assignment_status_types.user_status%TYPE

202: -- ----------------------------------------------------------------------------
203: -- |----------------------< get_asg_status_type >-----------------------------|
204: -- ----------------------------------------------------------------------------
205: FUNCTION get_asg_status_type(p_asg_sts_type_id IN NUMBER)
206: RETURN per_assignment_status_types.user_status%TYPE
207: IS
208: --
209: CURSOR csr_get_asg_sts_dtls
210: IS

Line 212: FROM per_assignment_status_types

208: --
209: CURSOR csr_get_asg_sts_dtls
210: IS
211: SELECT user_status
212: FROM per_assignment_status_types
213: WHERE assignment_status_type_id = p_asg_sts_type_id;
214:
215: l_proc_name VARCHAR2(80) := g_proc_name || 'get_asg_status_type';
216: l_proc_step PLS_INTEGER;

Line 217: l_user_status per_assignment_status_types.user_status%TYPE;

213: WHERE assignment_status_type_id = p_asg_sts_type_id;
214:
215: l_proc_name VARCHAR2(80) := g_proc_name || 'get_asg_status_type';
216: l_proc_step PLS_INTEGER;
217: l_user_status per_assignment_status_types.user_status%TYPE;
218: --
219: BEGIN
220: --
221: IF g_debug