DBA Data[Home] [Help]

APPS.IGF_SL_LAR_CREATION dependencies on IGF_AP_PR_PRG_TYPE

Line 964: cp_cs_schdl_id igf_ap_pr_prg_type.igs_pr_cs_schdl_id%TYPE ,

960:
961: -- Cursor to get dl_std_code
962: CURSOR c_dl_cl_std_code ( cp_ci_cal_type igf_ap_fa_base_rec.ci_cal_type%TYPE ,
963: cp_ci_sequence_number igf_ap_fa_base_rec.ci_sequence_number%TYPE ,
964: cp_cs_schdl_id igf_ap_pr_prg_type.igs_pr_cs_schdl_id%TYPE ,
965: cp_css_class_std_id igf_ap_class_std_map.igs_pr_css_class_std_id%TYPE ) IS
966: SELECT CSM.dl_std_code,
967: CSM.cl_std_code
968: FROM igf_ap_class_std_map CSM ,

Line 969: igf_ap_pr_prg_type PPT

965: cp_css_class_std_id igf_ap_class_std_map.igs_pr_css_class_std_id%TYPE ) IS
966: SELECT CSM.dl_std_code,
967: CSM.cl_std_code
968: FROM igf_ap_class_std_map CSM ,
969: igf_ap_pr_prg_type PPT
970: WHERE PPT.ppt_id = CSM.ppt_id
971: AND PPT.igs_pr_cs_schdl_id = cp_cs_schdl_id
972: AND PPT.cal_type = cp_ci_cal_type
973: AND PPT.sequence_number = cp_ci_sequence_number