APPS.AP_WEB_AUDIT_UTILS dependencies on AP_AUD_RULE_ASSIGNMENTS_ALL

Line 1110: from ap_aud_rule_assignments_all

1106: FUNCTION get_rule_set_assignment_exists(p_rule_set_id IN NUMBER) RETURN VARCHAR2 IS
1107:
1108: CURSOR assignment_cur IS
1109: select count(rule_assignment_id) assignment_count
1110: from ap_aud_rule_assignments_all
1111: where rule_set_id = p_rule_set_id;
1112:
1113: assignment_rec assignment_cur%ROWTYPE;
1114:

Line 1395: AP_AUD_RULE_ASSIGNMENTS_ALL rsa

1391:
1392: CURSOR rule_cur (p_org_id IN NUMBER) IS
1393: select rs.audit_term_duration_days
1394: from AP_AUD_RULE_SETS rs,
1395: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
1396: where rsa.org_id = p_org_id
1397: and rsa.rule_set_id = rs.rule_set_id
1398: and rs.rule_set_type = 'AUDIT_LIST'
1399: and TRUNC(SYSDATE)

Line 1565: AP_AUD_RULE_ASSIGNMENTS_ALL rsa

1561:
1562: CURSOR rule_cur IS
1563: select rs.rule_set_id
1564: from AP_AUD_RULE_SETS rs,
1565: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
1566: where rsa.org_id = p_org_id
1567: and rsa.rule_set_id = rs.rule_set_id
1568: and rs.rule_set_type = p_rule_type
1569: and TRUNC(SYSDATE)

Line 2909: AP_AUD_RULE_ASSIGNMENTS_ALL rsa

2905: nvl(aerh.image_receipts_status,'NOT_REQUIRED') hdr_img_receipt_required,
2906: nvl(aerh.receipts_status,'NOT_REQUIRED') hdr_paper_receipt_required
2907: from AP_EXPENSE_REPORT_HEADERS_ALL aerh,
2908: AP_AUD_RULE_SETS rs,
2909: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
2910: where aerh.report_header_id = p_report_header_id
2911: and aerh.org_id = rsa.org_id
2912: and rsa.rule_set_id = rs.rule_set_id
2913: and rs.rule_set_type = 'RULE'

Line 3192: AP_AUD_RULE_ASSIGNMENTS_ALL rsa

3188:
3189: CURSOR rule_cur IS
3190: select rs.*
3191: from AP_AUD_RULE_SETS rs,
3192: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
3193: where rsa.org_id = p_org_id
3194: and rsa.rule_set_id = rs.rule_set_id
3195: and rs.rule_set_type = p_rule_type
3196: and TRUNC(p_date)