APPS.IGS_PS_GEN_007 dependencies on IGS_GE_REF_CD_TYPE

Line 5: p_reference_cd_type IN IGS_GE_REF_CD_TYPE_ALL.reference_cd_type%TYPE ,

1: PACKAGE BODY IGS_PS_GEN_007 AS
2: /* $Header: IGSPS07B.pls 120.1 2006/04/17 05:59:37 sarakshi noship $ */
3:
4: FUNCTION crsp_get_rct_srct(
5: p_reference_cd_type IN IGS_GE_REF_CD_TYPE_ALL.reference_cd_type%TYPE ,
6: p_message_name OUT NOCOPY VARCHAR2)
7: RETURN VARCHAR2 AS
8: BEGIN
9: -- crsp_get_rct_srct

Line 15: FROM IGS_GE_REF_CD_TYPE rct,

11: DECLARE
12: v_s_reference_cd_type IGS_LOOKUPS_VIEW.lookup_code%TYPE;
13: CURSOR c_rct_srct IS
14: SELECT srct.lookup_code
15: FROM IGS_GE_REF_CD_TYPE rct,
16: IGS_LOOKUPS_VIEW srct
17: WHERE rct.reference_cd_type = p_reference_cd_type AND
18: rct.closed_ind = 'N' AND
19: srct.lookup_code = rct.s_reference_cd_type AND