APPS.IGF_SP_ASSIGN_PUB dependencies on IGF_AW_FUND_CAT

Line 108: FUNCTION validate_spnsr_cd(p_c_sponsor_code IN igf_aw_fund_cat.fund_code%TYPE) RETURN BOOLEAN

104: CLOSE cur_get_person_id;
105: END validate_api_prsn_id;
106:
107:
108: FUNCTION validate_spnsr_cd(p_c_sponsor_code IN igf_aw_fund_cat.fund_code%TYPE) RETURN BOOLEAN
109: AS
110: /****************************************************************************
111: Created By: Vinay Chappidi
112: Date Created By: 19-Feb-2003

Line 119: CURSOR c_check_valid_spnsr_cd(cp_c_fund_code igf_aw_fund_cat.fund_code%TYPE,

115:
116: Change History
117: Who When What
118: ******************************************************************************/
119: CURSOR c_check_valid_spnsr_cd(cp_c_fund_code igf_aw_fund_cat.fund_code%TYPE,
120: cp_c_sys_fund_type igf_aw_fund_cat.sys_fund_type%TYPE,
121: cp_c_status igf_aw_fund_cat.active%TYPE)
122: IS
123: SELECT 'x'

Line 120: cp_c_sys_fund_type igf_aw_fund_cat.sys_fund_type%TYPE,

116: Change History
117: Who When What
118: ******************************************************************************/
119: CURSOR c_check_valid_spnsr_cd(cp_c_fund_code igf_aw_fund_cat.fund_code%TYPE,
120: cp_c_sys_fund_type igf_aw_fund_cat.sys_fund_type%TYPE,
121: cp_c_status igf_aw_fund_cat.active%TYPE)
122: IS
123: SELECT 'x'
124: FROM igf_aw_fund_cat c,

Line 121: cp_c_status igf_aw_fund_cat.active%TYPE)

117: Who When What
118: ******************************************************************************/
119: CURSOR c_check_valid_spnsr_cd(cp_c_fund_code igf_aw_fund_cat.fund_code%TYPE,
120: cp_c_sys_fund_type igf_aw_fund_cat.sys_fund_type%TYPE,
121: cp_c_status igf_aw_fund_cat.active%TYPE)
122: IS
123: SELECT 'x'
124: FROM igf_aw_fund_cat c,
125: igf_aw_fund_mast m

Line 124: FROM igf_aw_fund_cat c,

120: cp_c_sys_fund_type igf_aw_fund_cat.sys_fund_type%TYPE,
121: cp_c_status igf_aw_fund_cat.active%TYPE)
122: IS
123: SELECT 'x'
124: FROM igf_aw_fund_cat c,
125: igf_aw_fund_mast m
126: WHERE c.fund_code = m.fund_code AND
127: c.fund_code = cp_c_fund_code AND
128: c.sys_fund_type = cp_c_sys_fund_type AND