DBA Data[Home] [Help]

APPS.AP_WEB_DB_EXPLINE_PKG dependencies on AP_EXP_REPORT_DISTS_ALL

Line 1804: FROM AP_EXP_REPORT_DISTS_ALL DT,

1800: DT.CREATED_BY,
1801: DT.PREPARER_MODIFIED_FLAG,
1802: DT.AMOUNT,
1803: DT.COST_CENTER
1804: FROM AP_EXP_REPORT_DISTS_ALL DT,
1805: AP_EXPENSE_REPORT_LINES_ALL DL
1806: WHERE DT.REPORT_LINE_ID = p_line_id
1807: AND DT.REPORT_LINE_ID = DL.REPORT_LINE_ID
1808: AND (DL.ITEMIZATION_PARENT_ID IS NULL

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

1930: allocation_split_code --Bug#6870253
1931: FROM ap_expense_report_lines erl
1932: WHERE report_line_id = p_report_line_id;
1933:
1934: -- for bug 5288256: insert a new row in ap_exp_report_dists_all table
1935: SELECT GL.SEGMENT1, GL.SEGMENT2,GL.SEGMENT3,GL.SEGMENT4, GL.SEGMENT5, GL.SEGMENT6,
1936: GL.SEGMENT7, GL.SEGMENT8,GL.SEGMENT9,GL.SEGMENT10,GL.SEGMENT11, GL.SEGMENT12,
1937: GL.SEGMENT13, GL.SEGMENT14, GL.SEGMENT15, GL.SEGMENT16, GL.SEGMENT17, GL.SEGMENT18,
1938: GL.SEGMENT19, GL.SEGMENT20, GL.SEGMENT21, GL.SEGMENT22, GL.SEGMENT23, GL.SEGMENT24,