APPS.AP_WEB_AUDIT_UTILS dependencies on AP_EXPENSE_REPORT_LINES_ALL

Line 650: AP_EXPENSE_REPORT_LINES_ALL aerl,

646: eo.exchange_rate_allowance,
647: eo.overall_tolerance,
648: eo.org_id
649: from AP_POL_EXRATE_OPTIONS_ALL eo,
650: AP_EXPENSE_REPORT_LINES_ALL aerl,
651: AP_EXPENSE_REPORT_HEADERS_ALL aerh,
652: AP_POL_VIOLATIONS_ALL pv
653: where aerl.report_header_id = pv.report_header_id
654: and aerl.distribution_line_number = pv.distribution_line_number

Line 796: from ap_expense_report_lines_all aerl,

792: FUNCTION get_concat_desc_flex(p_report_header_id IN NUMBER,
793: p_distribution_line_number IN NUMBER) RETURN VARCHAR2 IS
794: CURSOR template_cur IS
795: select prompt web_prompt
796: from ap_expense_report_lines_all aerl,
797: ap_expense_report_params_all aerp
798: where aerl.report_header_id = p_report_header_id
799: and aerl.distribution_line_number = p_distribution_line_number
800: and aerp.parameter_id = aerl.web_parameter_id;

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

889: IF p_report_header_id is null OR p_distribution_line_number is null OR p_column is null THEN
890: return null;
891: END IF;
892:
893: l_query_stmt := 'select '||p_column||' result from ap_expense_report_lines_all where report_header_id = :b1 and distribution_line_number = :b2';
894:
895: OPEN cur FOR l_query_stmt USING p_report_header_id, p_distribution_line_number;
896: FETCH cur INTO l_result_varchar;
897: CLOSE cur;

Line 1388: from AP_EXPENSE_REPORT_LINES_ALL aerl

1384: where aerh.report_header_id = p_report_header_id;
1385:
1386: CURSOR required_cur IS
1387: select count(1) required_count
1388: from AP_EXPENSE_REPORT_LINES_ALL aerl
1389: where aerl.report_header_id = p_report_header_id
1390: and nvl(aerl.receipt_required_flag, 'N') = 'Y';
1391:
1392: CURSOR rule_cur (p_org_id IN NUMBER) IS

Line 2199: FROM ap_expense_report_lines_all erl

2195: FUNCTION is_cc_expense_adjusted(p_report_header_id IN NUMBER) RETURN VARCHAR2 IS
2196:
2197: CURSOR cc_cur IS
2198: SELECT erl.report_header_id
2199: FROM ap_expense_report_lines_all erl
2200: WHERE erl.report_header_id = p_report_header_id
2201: AND erl.credit_card_trx_id is not null
2202: AND erl.amount <> NVL(erl.submitted_amount,erl.amount);
2203:

Line 2252: FROM ap_expense_report_lines_all erl

2248: FUNCTION is_itemized_expense_shortpaid(p_report_header_id IN NUMBER) RETURN VARCHAR2 IS
2249:
2250: CURSOR itemized_cur IS
2251: SELECT erl.report_header_id
2252: FROM ap_expense_report_lines_all erl
2253: WHERE erl.report_header_id = p_report_header_id
2254: AND erl.itemization_parent_id is not null
2255: AND erl.itemization_parent_id <> -1
2256: AND NVL(erl.policy_shortpay_flag,'N') = 'Y';

Line 2468: FROM AP_EXPENSE_REPORT_LINES_ALL

2464: FUNCTION get_next_distribution_line_id(p_report_header_id IN NUMBER) RETURN NUMBER IS
2465:
2466: CURSOR next_distribution_line_c(p_report_header_id NUMBER) IS
2467: SELECT max(distribution_line_number) + 1
2468: FROM AP_EXPENSE_REPORT_LINES_ALL
2469: WHERE report_header_id = p_report_header_id;
2470:
2471: ln_next_dist_line_number NUMBER;
2472:

Line 2816: from ap_expense_report_lines_all aerl,

2812: NVL(aerl.PER_DIEM_RATE2,0) PER_DIEM_RATE2,
2813: NVL(aerl.PER_DIEM_RATE3,0) PER_DIEM_RATE3,
2814: NVL(end_expense_date - start_expense_date,0)+1 number_of_days,
2815: ph.day_period_code
2816: from ap_expense_report_lines_all aerl,
2817: ap_pol_headers ph,
2818: ap_expense_report_params_all erp
2819: where aerl.report_header_id = p_report_header_id
2820: and aerl.distribution_line_number = p_distribution_line_number