APPS.IGC_CC_REP_YEP_PVT dependencies on IGC_CC_DET_PF_V

Line 290: FROM IGC_CC_DET_PF_V

286: WHERE IGC_CC_ACCT_LINES.CC_HEADER_ID = HEADER_ID;
287:
288: CURSOR C5(ACCT_LINE_ID NUMBER) IS
289: SELECT *
290: FROM IGC_CC_DET_PF_V
291: WHERE IGC_CC_DET_PF_V.CC_ACCT_LINE_ID = ACCT_LINE_ID;
292:
293: CURSOR C9 IS
294: SELECT *

Line 291: WHERE IGC_CC_DET_PF_V.CC_ACCT_LINE_ID = ACCT_LINE_ID;

287:
288: CURSOR C5(ACCT_LINE_ID NUMBER) IS
289: SELECT *
290: FROM IGC_CC_DET_PF_V
291: WHERE IGC_CC_DET_PF_V.CC_ACCT_LINE_ID = ACCT_LINE_ID;
292:
293: CURSOR C9 IS
294: SELECT *
295: FROM IGC_CC_HEADERS

Line 3117: FROM igc_cc_det_pf_v

3113: THEN
3114:
3115: SELECT cc_det_pf_func_amt,cc_det_pf_func_billed_amt
3116: INTO l_func_amt,l_func_billed_amt
3117: FROM igc_cc_det_pf_v
3118: WHERE cc_det_pf_line_id = p_cc_pmt_fcst_rec.cc_det_pf_line_id;
3119:
3120: l_unbilled_amt := l_func_amt - l_func_billed_amt;
3121:

Line 3205: FROM igc_cc_det_pf_v

3201: INTO l_ent_amt,
3202: l_func_amt,
3203: l_billed_amt,
3204: l_func_billed_amt
3205: FROM igc_cc_det_pf_v
3206: WHERE cc_det_pf_line_id = p_cc_pmt_fcst_rec.cc_det_pf_line_id;
3207: EXCEPTION
3208: WHEN NO_DATA_FOUND
3209: THEN

Line 3317: FROM igc_cc_det_pf_v

3313:
3314: BEGIN
3315: SELECT cc_det_pf_func_billed_amt
3316: INTO l_func_billed_amt
3317: FROM igc_cc_det_pf_v
3318: WHERE cc_det_pf_line_id = p_cc_pmt_fcst_rec.cc_det_pf_line_id;
3319: EXCEPTION
3320: WHEN NO_DATA_FOUND
3321: THEN