APPS.AP_WEB_AUDIT_PROCESS dependencies on AP_EXPENSE_REPORT_HEADERS_ALL

Line 71: FROM ap_expense_report_headers_all

67: l_parent_report_id NUMBER;
68: BEGIN
69:
70: SELECT shortpay_parent_id INTO l_parent_report_id
71: FROM ap_expense_report_headers_all
72: WHERE report_header_id = p_report_header_id;
73:
74: IF l_parent_report_id is NOT NULL THEN
75: SELECT audit_code into l_audit_code

Line 76: FROM ap_expense_report_headers_all

72: WHERE report_header_id = p_report_header_id;
73:
74: IF l_parent_report_id is NOT NULL THEN
75: SELECT audit_code into l_audit_code
76: FROM ap_expense_report_headers_all
77: WHERE report_header_id = l_parent_report_id;
78:
79: RETURN l_audit_code;
80: ELSE

Line 152: from AP_EXPENSE_REPORT_HEADERS_ALL aerh,

148: rs.audit_all_receipts_code,
149: rs.audit_all_justification_code,
150: rs.audit_all_inactive_code,
151: rs.audit_all_unused_advances
152: from AP_EXPENSE_REPORT_HEADERS_ALL aerh,
153: AP_AUD_RULE_SETS rs,
154: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
155: where aerh.report_header_id = p_report_header_id
156: and aerh.org_id = rsa.org_id

Line 170: l_old_audit_code ap_expense_report_headers_all.audit_code%type := null;

166: override_default_processing boolean := false;
167: l_bpay_personal_cc_only boolean := false;
168: l_shortpaid_report boolean := false;
169: audit_code VARCHAR2(30);
170: l_old_audit_code ap_expense_report_headers_all.audit_code%type := null;
171: l_old_audit_reason_code ap_aud_audit_reasons.audit_reason_code%type := null;
172: BEGIN
173:
174: IF p_report_header_id is null THEN

Line 273: from ap_expense_report_headers_all aerh,

269: into l_old_audit_reason_code, l_old_audit_code
270: from
271: (
272: select audit_code, audit_reason_code
273: from ap_expense_report_headers_all aerh,
274: ap_aud_audit_reasons aud
275: where aerh.report_header_id = p_report_header_id
276: and aerh.report_header_id = aud.report_header_id
277: and aud.audit_reason_code = 'RANDOM'

Line 659: from AP_EXPENSE_REPORT_HEADERS_ALL

655: p_audit_report OUT NOCOPY BOOLEAN) IS
656:
657: CURSOR report_cur IS
658: select AP_WEB_AUDIT_UTILS.is_employee_active(employee_id, org_id) active
659: from AP_EXPENSE_REPORT_HEADERS_ALL
660: where report_header_id = p_report_header_id;
661:
662: report_rec report_cur%ROWTYPE;
663:

Line 712: FROM ap_expense_report_headers_all XH,

708: INTO adv_not_applied_flag
709: FROM dual
710: WHERE EXISTS(
711: SELECT 'Y'
712: FROM ap_expense_report_headers_all XH,
713: ap_invoices_all AI,
714: po_vendors PV
715: WHERE XH.report_header_id = p_report_header_id
716: AND XH.prepay_num IS NULL

Line 772: from AP_EXPENSE_REPORT_HEADERS_ALL aerh,

768: CURSOR report_cur IS
769: select aerh.default_currency_code,
770: aerh.total,
771: sp.default_exchange_rate_type
772: from AP_EXPENSE_REPORT_HEADERS_ALL aerh,
773: ap_system_parameters_all sp
774: where aerh.report_header_id = p_report_header_id
775: and sp.org_id = aerh.org_id;
776:

Line 984: UPDATE ap_expense_report_headers_all erh

980:
981: IF ( p_report_header_id IS NOT NULL
982: AND p_audit_code IS NOT NULL) THEN
983:
984: UPDATE ap_expense_report_headers_all erh
985: SET audit_code = p_audit_code
986: WHERE report_header_id = p_report_header_id;
987: END IF;
988:

Line 1143: from AP_EXPENSE_REPORT_HEADERS_ALL aerh,

1139: rs.rule_set_type,
1140: rs.start_date,
1141: rs.end_date,
1142: rs.rule_set_id
1143: from AP_EXPENSE_REPORT_HEADERS_ALL aerh,
1144: AP_AUD_RULE_SETS rs,
1145: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
1146: where aerh.report_header_id = p_report_header_id
1147: and aerh.org_id = rsa.org_id

Line 1159: from AP_EXPENSE_REPORT_HEADERS_ALL aerh

1155: --card Report from report count.
1156: CURSOR reports_cur(p_employee_id IN NUMBER, p_org_id IN NUMBER) IS
1157: select sum(NVL(aerh.total,0)*NVL(aerh.default_exchange_rate,1)) expense_report_total,
1158: count(aerh.expense_report_id) expense_report_count
1159: from AP_EXPENSE_REPORT_HEADERS_ALL aerh
1160: where employee_id = p_employee_id
1161: and aerh.org_id = p_org_id
1162: and aerh.report_submitted_date > add_months(sysdate,-1)
1163: and ( aerh.source in ('WebExpense', 'SelfService')

Line 1608: AP_EXPENSE_REPORT_HEADERS_ALL aerh

1604:
1605: CURSOR violation_cur IS
1606: select count(1) violation_count
1607: from AP_POL_VIOLATIONS_ALL viol,
1608: AP_EXPENSE_REPORT_HEADERS_ALL aerh
1609: where aerh.employee_id = p_employee_id
1610: and viol.report_header_id = aerh.report_header_id
1611: and aerh.week_end_date > add_months(sysdate,-p_months);
1612: