APPS.AP_WEB_DB_EXPDIST_PKG dependencies on GL_CODE_COMBINATIONS

Line 471: FROM GL_CODE_COMBINATIONS

467: segment28,
468: segment29,
469: segment30,
470: AP_WEB_DB_EXPDIST_PKG.GetCCSegmentValue(p_ccid) -- Bug 7395568
471: FROM GL_CODE_COMBINATIONS
472: WHERE code_combination_id = p_ccid)
473: WHERE report_distribution_id = l_report_distribution_id
474: AND report_header_id = p_report_header_id;
475:

Line 590: FROM GL_CODE_COMBINATIONS

586: segment28,
587: segment29,
588: segment30,
589: AP_WEB_DB_EXPDIST_PKG.GetCCSegmentValue(p_ccid) -- Bug 7395568
590: FROM GL_CODE_COMBINATIONS
591: WHERE code_combination_id = p_ccid),
592: amount = p_line_amount
593: WHERE report_distribution_id = l_report_distribution_id
594: AND report_header_id = p_report_header_id;

Line 686: FROM GL_CODE_COMBINATIONS

682: segment28,
683: segment29,
684: segment30,
685: AP_WEB_DB_EXPDIST_PKG.GetCCSegmentValue(dist_lines_rec.CODE_COMBINATION_ID) -- Bug 7395568
686: FROM GL_CODE_COMBINATIONS
687: WHERE code_combination_id = dist_lines_rec.CODE_COMBINATION_ID)
688: WHERE CURRENT OF dist_lines_c;
689:
690: END IF;

Line 858: GL_CODE_COMBINATIONS GL

854: XH.flex_concatenated, -- Bug: 6735020, flex_concatenated should be fetched from headers
855: XL.web_parameter_id
856: FROM AP_EXPENSE_REPORT_LINES XL,
857: AP_EXPENSE_REPORT_HEADERS XH,
858: GL_CODE_COMBINATIONS GL
859: WHERE XL.report_line_id = p_report_line_id
860: AND XL.report_header_id = XH.report_header_id
861: AND GL.code_combination_id(+) = XL.code_combination_id;
862:

Line 1438: EXECUTE IMMEDIATE 'select '|| l_cc_segment_name || ' from gl_code_combinations where code_combination_id = :1'

1434: -- Fetch the cost center segment name
1435: AP_WEB_ACCTG_PKG.GetCostCenterSegmentName(l_cc_segment_name);
1436:
1437: -- Fetch the costcenter segment value.
1438: EXECUTE IMMEDIATE 'select '|| l_cc_segment_name || ' from gl_code_combinations where code_combination_id = :1'
1439: into l_segment_value
1440: using p_ccid;
1441:
1442: RETURN l_segment_value;