APPS.IGS_UC_EXP_APPLICANT_DTLS dependencies on IGS_PE_MATCH_SETS

Line 3149: CURSOR cur_match_set ( cp_source_type_id IGS_PE_MATCH_SETS.source_type_id%TYPE) IS

3145: WHO WHEN WHAT
3146:
3147: ***************************************************************** */
3148:
3149: CURSOR cur_match_set ( cp_source_type_id IGS_PE_MATCH_SETS.source_type_id%TYPE) IS
3150: SELECT match_set_id
3151: FROM IGS_PE_MATCH_SETS
3152: WHERE source_type_id = cp_source_type_id;
3153: l_match_set_id IGS_PE_MATCH_SETS.match_set_id%TYPE;

Line 3151: FROM IGS_PE_MATCH_SETS

3147: ***************************************************************** */
3148:
3149: CURSOR cur_match_set ( cp_source_type_id IGS_PE_MATCH_SETS.source_type_id%TYPE) IS
3150: SELECT match_set_id
3151: FROM IGS_PE_MATCH_SETS
3152: WHERE source_type_id = cp_source_type_id;
3153: l_match_set_id IGS_PE_MATCH_SETS.match_set_id%TYPE;
3154:
3155: -- Fetch the Interface ID for the passed Batch ID

Line 3153: l_match_set_id IGS_PE_MATCH_SETS.match_set_id%TYPE;

3149: CURSOR cur_match_set ( cp_source_type_id IGS_PE_MATCH_SETS.source_type_id%TYPE) IS
3150: SELECT match_set_id
3151: FROM IGS_PE_MATCH_SETS
3152: WHERE source_type_id = cp_source_type_id;
3153: l_match_set_id IGS_PE_MATCH_SETS.match_set_id%TYPE;
3154:
3155: -- Fetch the Interface ID for the passed Batch ID
3156: CURSOR cur_ad_interface ( cp_batch_id IGS_AD_INTERFACE_ALL.batch_id%TYPE) IS
3157: SELECT interface_id