eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGC_CC_REP_YEP_PVT dependencies on IGC_CC_DET_PF

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 2520: p_cc_pmt_fcst_rec IN igc_cc_det_pf%ROWTYPE,

2516: -- p_purch_encumbrance_type_id IN financials_system_params_all.purch_encumbrance_type_id%TYPE,
2517: p_currency_code IN VARCHAR2,
2518: p_cc_headers_rec IN igc_cc_headers%ROWTYPE,
2519: p_cc_acct_lines_rec IN igc_cc_acct_lines%ROWTYPE,
2520: p_cc_pmt_fcst_rec IN igc_cc_det_pf%ROWTYPE,
2521: p_mode IN VARCHAR2,
2522: p_type IN VARCHAR2,
2523: p_process_type IN VARCHAR2,
2524: p_yr_end_cr_date IN DATE,

Line 2565: l_cover_cc_det_pf_date igc_cc_det_pf.cc_det_pf_date%TYPE;

2561: l_cover_cc_acct_date igc_cc_headers.cc_acct_date%TYPE;
2562:
2563: l_cover_cc_acct_desc igc_cc_acct_lines.cc_acct_desc%TYPE;
2564: l_cover_budg_code_comb_id igc_cc_acct_lines.cc_budget_code_combination_id%TYPE;
2565: l_cover_cc_det_pf_date igc_cc_det_pf.cc_det_pf_date%TYPE;
2566:
2567:
2568: /* Begin for fix for bug 1689924*/
2569: l_cc_header_id igc_cc_headers.cc_header_id%TYPE;

Line 2805: FROM igc_cc_det_pf ccdpf

2801: WHERE
2802: igcci.cc_header_id = l_cc_header_id AND
2803: igcci.actual_flag = 'E' AND
2804: igcci.cc_det_pf_line_id IN (SELECT ccdpf.cc_det_pf_line_id
2805: FROM igc_cc_det_pf ccdpf
2806: WHERE cc_acct_line_id =
2807: l_cc_acct_line_id);
2808: EXCEPTION
2809: WHEN NO_DATA_FOUND

Line 2825: FROM igc_cc_det_pf ccdpf

2821: WHERE
2822: igcci.cc_header_id = l_cc_header_id AND
2823: igcci.actual_flag = 'E' AND
2824: igcci.cc_det_pf_line_id IN (SELECT ccdpf.cc_det_pf_line_id
2825: FROM igc_cc_det_pf ccdpf
2826: WHERE cc_acct_line_id =
2827: l_cc_acct_line_id);
2828: EXCEPTION
2829: WHEN NO_DATA_FOUND

Line 2966: FROM igc_cc_det_pf ccdpf

2962: WHERE
2963: igcci.cc_header_id = p_cc_headers_rec.cc_header_id AND
2964: igcci.actual_flag = 'E' AND
2965: cc_det_pf_line_id IN (SELECT ccdpf.cc_det_pf_line_id
2966: FROM igc_cc_det_pf ccdpf
2967: WHERE cc_acct_line_id =
2968: p_cc_acct_lines_rec.cc_acct_line_id);
2969: END IF;
2970:

Line 2982: FROM igc_cc_det_pf ccdpf

2978: WHERE
2979: igcci.cc_header_id = p_cc_headers_rec.cc_header_id AND
2980: igcci.actual_flag = 'E' AND
2981: cc_det_pf_line_id IN (SELECT ccdpf.cc_det_pf_line_id
2982: FROM igc_cc_det_pf ccdpf
2983: WHERE cc_acct_line_id =
2984: p_cc_acct_lines_rec.cc_acct_line_id);
2985: END IF;
2986:

Line 3092: FROM igc_cc_det_pf

3088: l_cover_cc_det_pf_date := NULL;
3089:
3090: SELECT cc_det_pf_date
3091: INTO l_cover_cc_det_pf_date
3092: FROM igc_cc_det_pf
3093: WHERE cc_det_pf_line_id = p_cc_pmt_fcst_rec.parent_det_pf_line_id;
3094: ELSE
3095: /*Bug No : 6341012. SLA Uptake. CC_Account_line_id should not be Null */
3096: l_cc_interface_rec.cc_acct_line_id := p_cc_acct_lines_rec.cc_acct_line_id;

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

Line 3438: l_cc_pmt_fcst_rec igc_cc_det_pf%ROWTYPE;

3434: l_interface_row_count NUMBER;
3435: l_insert_status VARCHAR2(1);
3436: l_cc_headers_rec igc_cc_headers%ROWTYPE;
3437: l_cc_acct_lines_rec igc_cc_acct_lines%ROWTYPE;
3438: l_cc_pmt_fcst_rec igc_cc_det_pf%ROWTYPE;
3439:
3440: l_cover_set_of_books_id igc_cc_headers.set_of_books_id%TYPE;
3441:
3442: l_process_account_row BOOLEAN := FALSE;

Line 3460: FROM igc_cc_det_pf

3456:
3457: /* Contract Commitment detail payment forecast */
3458: CURSOR c_payment_forecast(t_cc_acct_line_id NUMBER) IS
3459: SELECT *
3460: FROM igc_cc_det_pf
3461: WHERE cc_acct_line_id = t_cc_acct_line_id;
3462: /* Current year payment forecast lines only */
3463:
3464: /* Contract Commitment account lines */