APPS.AP_WEB_HOLDS_WF dependencies on AP_AUD_RULE_ASSIGNMENTS_ALL

Line 66: AP_AUD_RULE_ASSIGNMENTS_ALL rsa

62: ------------------------------------------------------------
63: select 'Y'
64: into l_is_holds_rule_setup
65: from AP_AUD_RULE_SETS rs,
66: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
67: where rsa.org_id = p_org_id
68: and rsa.rule_set_id = rs.rule_set_id
69: and rs.rule_set_type = C_HOLD_RULE
70: and TRUNC(p_report_submitted_date)

Line 701: AP_AUD_RULE_ASSIGNMENTS_ALL rsa

697: ------------------------------------------------------------
698: select rs.hold_code
699: into l_hold_code
700: from AP_AUD_RULE_SETS rs,
701: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
702: where rsa.org_id = p_org_id
703: and rsa.rule_set_id = rs.rule_set_id
704: and rs.rule_set_type = C_HOLD_RULE
705: and TRUNC(p_report_submitted_date)

Line 1321: AP_AUD_RULE_ASSIGNMENTS_ALL rsa

1317: aerh.report_submitted_date,
1318: aerh.org_id
1319: from AP_EXPENSE_REPORT_HEADERS aerh,
1320: AP_AUD_RULE_SETS rs,
1321: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
1322: where aerh.source = AP_WEB_RECEIPTS_WF.C_SELF_SERVICE_SOURCE
1323: and aerh.expense_status_code in (AP_WEB_RECEIPTS_WF.C_PAYMENT_HELD, AP_WEB_RECEIPTS_WF.C_PENDING_HOLDS)
1324: and aerh.bothpay_parent_id is null
1325: and rsa.org_id = aerh.org_id

Line 1649: AP_AUD_RULE_ASSIGNMENTS_ALL rsa

1645: aerh.employee_id,
1646: rs.hold_rct_overdue_days
1647: from AP_EXPENSE_REPORT_HEADERS aerh,
1648: AP_AUD_RULE_SETS rs,
1649: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
1650: where aerh.source = AP_WEB_RECEIPTS_WF.C_SELF_SERVICE_SOURCE
1651: and aerh.expense_status_code in (AP_WEB_RECEIPTS_WF.C_PAYMENT_HELD, AP_WEB_RECEIPTS_WF.C_PENDING_HOLDS)
1652: and aerh.bothpay_parent_id is null
1653: and rsa.org_id = aerh.org_id

Line 1990: AP_AUD_RULE_ASSIGNMENTS_ALL rsa

1986: rs.hold_rct_overdue_bp_cc_code
1987: from AP_EXPENSE_REPORT_HEADERS aerh,
1988: AP_EXPENSE_REPORT_HEADERS aerh2,
1989: AP_AUD_RULE_SETS rs,
1990: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
1991: where aerh.source in (AP_WEB_RECEIPTS_WF.C_SELF_SERVICE_SOURCE, AP_WEB_RECEIPTS_WF.C_BOTHPAY)
1992: and aerh.expense_status_code in (AP_WEB_RECEIPTS_WF.C_PAYMENT_HELD, AP_WEB_RECEIPTS_WF.C_PENDING_HOLDS)
1993: and aerh.bothpay_parent_id is not null
1994: and aerh2.report_header_id = aerh.bothpay_parent_id

Line 2221: AP_AUD_RULE_ASSIGNMENTS_ALL rsa

2217: and
2218: not exists
2219: (select 1
2220: from AP_AUD_RULE_SETS rs,
2221: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
2222: where rsa.org_id = aerh.org_id
2223: and rsa.rule_set_id = rs.rule_set_id
2224: and rs.rule_set_type = C_HOLD_RULE
2225: and TRUNC(aerh.report_submitted_date)

Line 2370: AP_AUD_RULE_ASSIGNMENTS_ALL rsa

2366:
2367: CURSOR ReceiptRuleCur IS
2368: SELECT rs.*
2369: FROM AP_AUD_RULE_SETS rs,
2370: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
2371: WHERE rsa.org_id = p_org_id
2372: AND rsa.rule_set_id = rs.rule_set_id
2373: AND rs.rule_set_type = 'RECEIPT'
2374: AND TRUNC(p_report_date) BETWEEN TRUNC(NVL(rsa.start_date,p_report_date)) AND TRUNC(NVL(rsa.end_date,p_report_date));