APPS.AP_WEB_UTILITIES_PKG dependencies on AP_AUD_RULE_SETS

Line 3526: ap_aud_rule_sets rs,

3522: AP_WEB_UTILITIES_PKG.AddReportToAuditQueue(p_report_header_id);
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

Line 3564: ap_aud_rule_sets rs,

3560: select nvl(rs.recpt_assign_stage_code,'X'), NVL(rs.AUD_IMG_RECEIPT_REQUIRED, 'N') ,
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

Line 3689: FROM AP_AUD_RULE_SETS rs,

3685: FUNCTION GetReceiptRuleExists(p_report_header_id IN NUMBER, p_org_id IN NUMBER) RETURN VARCHAR2 IS
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'