APPS.AP_WEB_UTILITIES_PKG dependencies on AP_AUD_RULE_ASSIGNMENTS_ALL

Line 3527: ap_aud_rule_assignments_all rsa

3523: /*
3524: select nvl(rs.recpt_assign_stage_code,'X') into l_stage_code
3525: from ap_expense_report_headers_all aerh,
3526: ap_aud_rule_sets rs,
3527: ap_aud_rule_assignments_all rsa
3528: where aerh.report_header_id = p_report_header_id
3529: and aerh.org_id = rsa.org_id
3530: and rsa.rule_set_id = rs.rule_set_id
3531: and rs.rule_set_type = 'RULE'

Line 3565: ap_aud_rule_assignments_all rsa

3561: nvl(rs.AUD_PAPER_RECEIPT_REQUIRED, 'N')
3562: into l_stage_code, l_aud_img_required, l_aud_org_required
3563: from ap_expense_report_headers_all aerh,
3564: ap_aud_rule_sets rs,
3565: ap_aud_rule_assignments_all rsa
3566: where aerh.report_header_id = p_report_header_id
3567: and aerh.org_id = rsa.org_id
3568: and rsa.rule_set_id = rs.rule_set_id
3569: and rs.rule_set_type = 'RULE'

Line 3690: AP_AUD_RULE_ASSIGNMENTS_ALL rsa

3686:
3687: CURSOR ReceiptRuleCur(p_report_date IN DATE) IS
3688: SELECT rs.*
3689: FROM AP_AUD_RULE_SETS rs,
3690: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
3691: WHERE rsa.org_id = p_org_id
3692: AND rsa.rule_set_id = rs.rule_set_id
3693: AND rs.rule_set_type = 'RECEIPT'
3694: AND TRUNC(p_report_date) BETWEEN TRUNC(NVL(rsa.start_date,p_report_date)) AND TRUNC(NVL(rsa.end_date,p_report_date));