APPS.AP_WEB_AUDIT_UTILS dependencies on AP_EXPENSE_REPORT_LINES_ALL

Line 617: AP_EXPENSE_REPORT_LINES_ALL aerl,

613: eo.exchange_rate_allowance,
614: eo.overall_tolerance,
615: eo.org_id
616: from AP_POL_EXRATE_OPTIONS_ALL eo,
617: AP_EXPENSE_REPORT_LINES_ALL aerl,
618: AP_EXPENSE_REPORT_HEADERS_ALL aerh,
619: AP_POL_VIOLATIONS_ALL pv
620: where aerl.report_header_id = pv.report_header_id
621: and aerl.distribution_line_number = pv.distribution_line_number

Line 757: from ap_expense_report_lines_all aerl,

753: FUNCTION get_concat_desc_flex(p_report_header_id IN NUMBER,
754: p_distribution_line_number IN NUMBER) RETURN VARCHAR2 IS
755: CURSOR template_cur IS
756: select prompt web_prompt
757: from ap_expense_report_lines_all aerl,
758: ap_expense_report_params_all aerp
759: where aerl.report_header_id = p_report_header_id
760: and aerl.distribution_line_number = p_distribution_line_number
761: and aerp.parameter_id = aerl.web_parameter_id;

Line 854: l_query_stmt := 'select '||p_column||' result from ap_expense_report_lines_all where report_header_id = :b1 and distribution_line_number = :b2';

850: IF p_report_header_id is null OR p_distribution_line_number is null OR p_column is null THEN
851: return null;
852: END IF;
853:
854: l_query_stmt := 'select '||p_column||' result from ap_expense_report_lines_all where report_header_id = :b1 and distribution_line_number = :b2';
855:
856: OPEN cur FOR l_query_stmt USING p_report_header_id, p_distribution_line_number;
857: FETCH cur INTO l_result_varchar;
858: CLOSE cur;

Line 1349: from AP_EXPENSE_REPORT_LINES_ALL aerl

1345: where aerh.report_header_id = p_report_header_id;
1346:
1347: CURSOR required_cur IS
1348: select count(1) required_count
1349: from AP_EXPENSE_REPORT_LINES_ALL aerl
1350: where aerl.report_header_id = p_report_header_id
1351: and nvl(aerl.receipt_required_flag, 'N') = 'Y';
1352:
1353: CURSOR rule_cur (p_org_id IN NUMBER) IS

Line 2157: FROM ap_expense_report_lines_all erl

2153: FUNCTION is_cc_expense_adjusted(p_report_header_id IN NUMBER) RETURN VARCHAR2 IS
2154:
2155: CURSOR cc_cur IS
2156: SELECT erl.report_header_id
2157: FROM ap_expense_report_lines_all erl
2158: WHERE erl.report_header_id = p_report_header_id
2159: AND erl.credit_card_trx_id is not null
2160: AND erl.amount <> NVL(erl.submitted_amount,erl.amount);
2161:

Line 2210: FROM ap_expense_report_lines_all erl

2206: FUNCTION is_itemized_expense_shortpaid(p_report_header_id IN NUMBER) RETURN VARCHAR2 IS
2207:
2208: CURSOR itemized_cur IS
2209: SELECT erl.report_header_id
2210: FROM ap_expense_report_lines_all erl
2211: WHERE erl.report_header_id = p_report_header_id
2212: AND erl.itemization_parent_id is not null
2213: AND erl.itemization_parent_id <> -1
2214: AND NVL(erl.policy_shortpay_flag,'N') = 'Y';

Line 2426: FROM AP_EXPENSE_REPORT_LINES_ALL

2422: FUNCTION get_next_distribution_line_id(p_report_header_id IN NUMBER) RETURN NUMBER IS
2423:
2424: CURSOR next_distribution_line_c(p_report_header_id NUMBER) IS
2425: SELECT max(distribution_line_number) + 1
2426: FROM AP_EXPENSE_REPORT_LINES_ALL
2427: WHERE report_header_id = p_report_header_id;
2428:
2429: ln_next_dist_line_number NUMBER;
2430:

Line 2774: from ap_expense_report_lines_all aerl,

2770: NVL(aerl.PER_DIEM_RATE2,0) PER_DIEM_RATE2,
2771: NVL(aerl.PER_DIEM_RATE3,0) PER_DIEM_RATE3,
2772: NVL(end_expense_date - start_expense_date,0)+1 number_of_days,
2773: ph.day_period_code
2774: from ap_expense_report_lines_all aerl,
2775: ap_pol_headers ph,
2776: ap_expense_report_params_all erp
2777: where aerl.report_header_id = p_report_header_id
2778: and aerl.distribution_line_number = p_distribution_line_number