DBA Data[Home] [Help]

APPS.AP_WEB_DB_EXPDIST_PKG dependencies on GL_CODE_COMBINATIONS

Line 468: FROM GL_CODE_COMBINATIONS

464: segment27,
465: segment28,
466: segment29,
467: segment30
468: FROM GL_CODE_COMBINATIONS
469: WHERE code_combination_id = p_ccid)
470: WHERE report_distribution_id = l_report_distribution_id
471: AND report_header_id = p_report_header_id;
472:

Line 585: FROM GL_CODE_COMBINATIONS

581: segment27,
582: segment28,
583: segment29,
584: segment30
585: FROM GL_CODE_COMBINATIONS
586: WHERE code_combination_id = p_ccid),
587: amount = p_line_amount
588: WHERE report_distribution_id = l_report_distribution_id
589: AND report_header_id = p_report_header_id;

Line 679: FROM GL_CODE_COMBINATIONS

675: segment27,
676: segment28,
677: segment29,
678: segment30
679: FROM GL_CODE_COMBINATIONS
680: WHERE code_combination_id = dist_lines_rec.CODE_COMBINATION_ID)
681: WHERE CURRENT OF dist_lines_c;
682:
683: END IF;

Line 849: GL_CODE_COMBINATIONS GL

845: XL.expenditure_organization_id,
846: XH.flex_concatenated -- Bug: 6735020, flex_concatenated should be fetched from headers
847: FROM AP_EXPENSE_REPORT_LINES XL,
848: AP_EXPENSE_REPORT_HEADERS XH,
849: GL_CODE_COMBINATIONS GL
850: WHERE XL.report_line_id = p_report_line_id
851: AND XL.report_header_id = XH.report_header_id
852: AND GL.code_combination_id(+) = XL.code_combination_id;
853: