DBA Data[Home] [Help]

APPS.AP_WEB_EXPENSE_FORM dependencies on AP_EXPENSE_REPORT_LINES

Line 75: ap_expense_report_lines erl

71: begin
72: select erp.category_code
73: into l_category_code
74: from ap_expense_report_params erp,
75: ap_expense_report_lines erl
76: where erl.report_header_id = p_report_header_id
77: and erl.distribution_line_number = p_distribution_line_number
78: and erl.web_parameter_id = erp.parameter_id;
79:

Line 117: from ap_expense_report_lines_all aerp

113: * This can be done since ecen though report_header_id is not
114: * a unique key, there can be only one report header id across orgs. */
115: select count(*)
116: into l_count
117: from ap_expense_report_lines_all aerp
118: where report_header_id = p_report_header_id
119: and (itemization_parent_id is null or itemization_parent_id <> -1)
120: and exists (select 1 from ap_pol_violations_all apv
121: where apv.report_header_id = p_report_header_id