APPS.IGF_SL_LAR_CREATION dependencies on IGF_SL_CL_SETUP_ALL

Line 132: cl_setup_rec igf_sl_cl_setup_all%ROWTYPE;

128: -- FA 134
129:
130: award_rec igf_aw_award_v%ROWTYPE;
131: dl_setup_rec igf_sl_dl_setup_all%ROWTYPE;
132: cl_setup_rec igf_sl_cl_setup_all%ROWTYPE;
133: p_incr_date_code VARCHAR2(100);
134:
135: g_s_default_status igf_sl_lor_all.s_default_status%TYPE;
136: g_p_default_status igf_sl_lor_all.p_default_status%TYPE;

Line 1570: FROM igf_sl_cl_setup_all

1566: cp_rel_code igf_sl_cl_setup_v.relationship_cd%TYPE,
1567: cp_party_id igf_sl_cl_setup.party_id%TYPE
1568: ) IS
1569: SELECT *
1570: FROM igf_sl_cl_setup_all
1571: WHERE ci_cal_type = cp_cal_type
1572: AND ci_sequence_number = cp_seq_number
1573: AND relationship_cd = cp_rel_code
1574: AND NVL(party_id,-1000) = NVL(cp_party_id,-1000);

Line 3187: FROM igf_sl_cl_setup_all

3183: AND ci_sequence_number = p_ci_sequence_number;
3184:
3185: CURSOR cur_cl_setup IS
3186: SELECT *
3187: FROM igf_sl_cl_setup_all
3188: WHERE ci_cal_type = p_ci_cal_type
3189: AND ci_sequence_number = p_ci_sequence_number;
3190:
3191: --Cursor to get the alternate code for the calendar instance