APPS.AP_WEB_EXPENSE_WF dependencies on AP_AUD_RULE_SETS

Line 14401: ap_aud_rule_sets rs,

14397: rs.paperless_audit_violation_flag,
14398: rs.paperless_audit_pdm_only_flag,
14399: aerh.workflow_approved_flag
14400: from ap_expense_report_headers aerh,
14401: ap_aud_rule_sets rs,
14402: ap_aud_rule_assignments_all rsa
14403: where aerh.report_header_id = p_report_header_id
14404: and aerh.org_id = rsa.org_id
14405: and rsa.rule_set_id = rs.rule_set_id

Line 14416: ap_aud_rule_sets rs,

14412: select rs.recpt_assign_stage_code,
14413: rs.AUD_IMG_RECEIPT_REQUIRED,
14414: rs.AUD_PAPER_RECEIPT_REQUIRED
14415: from ap_expense_report_headers aerh,
14416: ap_aud_rule_sets rs,
14417: ap_aud_rule_assignments_all rsa
14418: where aerh.report_header_id = p_report_header_id
14419: and aerh.org_id = rsa.org_id
14420: and rsa.rule_set_id = rs.rule_set_id

Line 17329: ap_aud_rule_sets rs,

17325: ELSE
17326: select nvl(rs.image_req_appr_flag,'X'),
17327: nvl(aerh.image_receipts_status, 'NOT_REQUIRED') into l_req_mgr_appr,l_img_recpt_status
17328: from ap_expense_report_headers aerh,
17329: ap_aud_rule_sets rs,
17330: ap_aud_rule_assignments_all rsa
17331: where aerh.report_header_id = l_report_header_id
17332: and aerh.org_id = rsa.org_id
17333: and rsa.rule_set_id = rs.rule_set_id

Line 17390: ap_aud_rule_sets rs,

17386: ELSE
17387: select nvl(rs.req_reappr_flag,'X')
17388: into l_re_appr_flag
17389: from ap_expense_report_headers aerh,
17390: ap_aud_rule_sets rs,
17391: ap_aud_rule_assignments_all rsa
17392: where aerh.report_header_id = l_report_header_id
17393: and aerh.org_id = rsa.org_id
17394: and rsa.rule_set_id = rs.rule_set_id