APPS.IGC_CC_COMMON_UTILS_PVT dependencies on IGC_CC_ACCT_LINES

Line 394: FROM IGC_CC_ACCT_LINES

390: -- Cursor to get the account line id value
391: CURSOR c_acct_line(p_cc_num IN po_headers.segment1%type)
392: IS
393: SELECT CC_acct_LINE_ID
394: FROM IGC_CC_ACCT_LINES
395: WHERE cc_header_id = (SELECT cc_header_id
396: FROM IGC_CC_HEADERS
397: WHERE CC_NUM = p_cc_num)
398: AND CC_ACCT_LINE_NUM = x_shipment_num;

Line 422: FROM igc_cc_acct_lines

418: WHERE po_line_id = p_po_line_id;
419:
420: CURSOR c_get_cc_acct_line_id(p_shipment_num po_line_locations.shipment_num%type)
421: IS SELECT cc_acct_line_id
422: FROM igc_cc_acct_lines
423: WHERE cc_header_id = (SELECT cc_header_id
424: FROM IGC_CC_HEADERS
425: WHERE CC_NUM = l_cc_num)
426: AND cc_acct_line_num = p_shipment_num;

Line 585: FROM IGC_CC_ACCT_LINES

581: SELECT CC_DET_PF_DATE
582: INTO l_pf_date
583: FROM IGC_CC_DET_PF
584: WHERE CC_acct_LINE_ID = (SELECT CC_acct_LINE_ID
585: FROM IGC_CC_ACCT_LINES
586: WHERE cc_header_id = (SELECT cc_header_id
587: FROM IGC_CC_HEADERS
588: WHERE CC_NUM = l_cc_num)
589: AND CC_ACCT_LINE_NUM = x_shipment_num)