APPS.IGS_GE_GEN_003 dependencies on IGS_CA_INST

Line 712: FROM igs_ca_inst

708: --
709: -- cursor to fetch the count of calendar instances exists for the given alternate code
710: CURSOR cur_cal_inst_cnt IS
711: SELECT count(*)
712: FROM igs_ca_inst
713: WHERE alternate_code = p_alternate_cd;
714:
715: --
716: -- cursor to fetch the details of calendar instances for the given alternate code

Line 719: FROM igs_ca_inst

715: --
716: -- cursor to fetch the details of calendar instances for the given alternate code
717: CURSOR cur_cal_inst_dtls IS
718: SELECT cal_type,sequence_number,start_dt,end_dt
719: FROM igs_ca_inst
720: WHERE alternate_code = p_alternate_cd;
721:
722: l_cal_inst_cnt NUMBER;
723: l_cal_cat_inst_cnt NUMBER;

Line 759: fnd_dsql.add_text('SELECT ci.cal_type,ci.sequence_number,ci.start_dt,ci.end_dt FROM igs_ca_inst_all ci, igs_ca_type ct WHERE alternate_code =');

755: next_pos_lv := 1;
756:
757: -- Query to get the count of calendar instances for the given alternate code and calendar categories
758:
759: fnd_dsql.add_text('SELECT ci.cal_type,ci.sequence_number,ci.start_dt,ci.end_dt FROM igs_ca_inst_all ci, igs_ca_type ct WHERE alternate_code =');
760: fnd_dsql.add_bind(p_alternate_cd);
761: fnd_dsql.add_text(' AND ci.cal_type = ct.cal_type AND ct.s_cal_cat IN (');
762:
763: LOOP