DBA Data[Home] [Help]

APPS.AP_WEB_DB_EXPLINE_PKG dependencies on AP_EXP_REPORT_DISTS_ALL

Line 2048: FROM AP_EXP_REPORT_DISTS_ALL DT,

2044: DT.CREATED_BY,
2045: DT.PREPARER_MODIFIED_FLAG,
2046: DT.AMOUNT,
2047: DT.COST_CENTER
2048: FROM AP_EXP_REPORT_DISTS_ALL DT,
2049: AP_EXPENSE_REPORT_LINES_ALL DL
2050: WHERE DT.REPORT_LINE_ID = p_line_id
2051: AND DT.REPORT_LINE_ID = DL.REPORT_LINE_ID
2052: AND (DL.ITEMIZATION_PARENT_ID IS NULL

Line 2178: -- for bug 5288256: insert a new row in ap_exp_report_dists_all table

2174: allocation_split_code --Bug#6870253
2175: FROM ap_expense_report_lines erl
2176: WHERE report_line_id = p_report_line_id;
2177:
2178: -- for bug 5288256: insert a new row in ap_exp_report_dists_all table
2179: SELECT GL.SEGMENT1, GL.SEGMENT2,GL.SEGMENT3,GL.SEGMENT4, GL.SEGMENT5, GL.SEGMENT6,
2180: GL.SEGMENT7, GL.SEGMENT8,GL.SEGMENT9,GL.SEGMENT10,GL.SEGMENT11, GL.SEGMENT12,
2181: GL.SEGMENT13, GL.SEGMENT14, GL.SEGMENT15, GL.SEGMENT16, GL.SEGMENT17, GL.SEGMENT18,
2182: GL.SEGMENT19, GL.SEGMENT20, GL.SEGMENT21, GL.SEGMENT22, GL.SEGMENT23, GL.SEGMENT24,