DBA Data[Home] [Help]

APPS.IGC_CC_COMP_AMT_PKG dependencies on IGC_CC_DET_PF_V

Line 142: FROM igc_cc_det_pf_v

138: THEN
139: BEGIN
140: SELECT NVL(SUM(NVL(cc_det_pf_func_billed_amt,0)),0)
141: INTO l_func_billed_amount
142: FROM igc_cc_det_pf_v
143: WHERE parent_det_pf_line_id = p_cc_det_pf_line_id;
144: EXCEPTION
145: WHEN NO_DATA_FOUND
146: THEN

Line 228: FROM igc_cc_det_pf_v

224:
225: BEGIN
226: SELECT NVL(SUM(NVL(cc_det_pf_billed_amt,0)),0)
227: INTO l_billed_amount
228: FROM igc_cc_det_pf_v
229: WHERE parent_det_pf_line_id = p_cc_det_pf_line_id;
230: EXCEPTION
231: WHEN NO_DATA_FOUND
232: THEN

Line 458: FROM igc_cc_det_pf_v

454: THEN
455: BEGIN
456: SELECT NVL(SUM(NVL(cc_det_pf_func_billed_amt,0)),0)
457: INTO l_func_billed_amount
458: FROM igc_cc_det_pf_v
459: WHERE parent_det_pf_line_id = p_cc_det_pf_line_id;
460: EXCEPTION
461: WHEN NO_DATA_FOUND
462: THEN