APPS.IGF_AP_LG_TD_IMP dependencies on IGF_AP_TD_ITEM_MST_ALL

Line 209: l_todo_number igf_ap_td_item_mst_all.todo_number%TYPE := NULL;

205: l_chk_profile VARCHAR2(1) := 'Y';
206: l_debug_str VARCHAR2(800) := NULL;
207: l_total_record_cnt NUMBER := 0;
208: l_get_meaning igf_lookups_view.meaning%TYPE := NULL;
209: l_todo_number igf_ap_td_item_mst_all.todo_number%TYPE := NULL;
210:
211: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ;
212: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
213:

Line 287: FROM igf_ap_td_item_mst_all

283: cp_item_code VARCHAR2)
284: IS
285: (
286: SELECT todo_number
287: FROM igf_ap_td_item_mst_all
288: WHERE ci_cal_type = cp_cal_type
289: AND ci_sequence_number = cp_seq_number
290: AND item_code = NVL(cp_item_code,item_code)
291: AND CAREER_ITEM = 'N'

Line 294: FROM igf_ap_td_item_mst_all

290: AND item_code = NVL(cp_item_code,item_code)
291: AND CAREER_ITEM = 'N'
292: UNION
293: SELECT todo_number
294: FROM igf_ap_td_item_mst_all
295: WHERE item_code = NVL(cp_item_code,item_code)
296: AND CAREER_ITEM = 'Y'
297: );
298:

Line 329: FROM igf_ap_td_item_mst_all

325: cp_seq_number igs_ca_inst_all.sequence_number%TYPE
326: )
327: IS
328: SELECT system_todo_type_code
329: FROM igf_ap_td_item_mst_all
330: WHERE
331: item_code = cp_item_code AND
332: system_todo_type_code IS NOT NULL;
333:

Line 334: l_item_system_todo_type_code igf_ap_td_item_mst_all.system_todo_type_code%TYPE;

330: WHERE
331: item_code = cp_item_code AND
332: system_todo_type_code IS NOT NULL;
333:
334: l_item_system_todo_type_code igf_ap_td_item_mst_all.system_todo_type_code%TYPE;
335:
336: CURSOR c_chk_lender_rel (cp_rel_cd igf_sl_cl_recipient.relationship_cd%TYPE)
337: IS
338: SELECT 'X'

Line 798: igf_ap_td_item_mst_all tdmst

794: )
795: IS
796: SELECT 1
797: FROM igf_ap_td_item_inst_all tdinst,
798: igf_ap_td_item_mst_all tdmst
799: WHERE tdinst.base_id = cp_base_id
800: AND tdinst.status IN ('INC','REQ','REC')
801: AND tdinst.required_for_application = 'Y'
802: AND NVL(tdinst.inactive_flag,'N') <> 'Y'

Line 809: igf_ap_td_item_mst_all tdmst,

805: AND ROWNUM < 2
806: UNION
807: SELECT 1
808: FROM igf_ap_td_item_inst_all tdinst,
809: igf_ap_td_item_mst_all tdmst,
810: igf_ap_fa_base_rec_all fa
811: WHERE tdinst.base_id = fa.base_id
812: AND tdinst.status IN ('INC','REQ','REC')
813: AND tdinst.required_for_application = 'Y'