APPS.IGC_CC_COMMON_UTILS_PVT dependencies on IGC_CC_ACCT_LINES

Line 396: FROM IGC_CC_ACCT_LINES

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

Line 424: FROM igc_cc_acct_lines

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

Line 587: FROM IGC_CC_ACCT_LINES

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