APPS.AP_WEB_POLICY_UTILS dependencies on OIE_DUP_DETECT_RS_DETAIL

Line 6688: AND (EXISTS(SELECT 1 FROM oie_dup_detect_rs_detail rs WHERE rs.rule_id = rule.rule_id)

6684: -- 'rule' assigned to any operating unit
6685: SELECT count(*) assignment_count
6686: FROM oie_dup_detect_rules rule
6687: WHERE rule.rule_id = p_rule_id
6688: AND (EXISTS(SELECT 1 FROM oie_dup_detect_rs_detail rs WHERE rs.rule_id = rule.rule_id)
6689: OR EXISTS(SELECT 1 FROM oie_dup_rule_assignments_all rsa WHERE rsa.rule_id = rule.rule_id));
6690:
6691: assignment_rule_rec assignment_rule_cur%ROWTYPE;
6692:

Line 7007: FROM oie_dup_detect_rs_detail

7003: FROM ap_lookup_codes WHERE lookup_type = 'OIE_EXPENSE_CATEGORY'
7004: AND lookup_code = p_category_code;
7005:
7006: SELECT rule_id INTO l_rule_id
7007: FROM oie_dup_detect_rs_detail
7008: WHERE rule_set_id = l_rule_set_id AND category_code = l_category_code;
7009:
7010: EXCEPTION
7011: WHEN No_Data_Found THEN

Line 7015: FROM oie_dup_detect_rs_detail

7011: WHEN No_Data_Found THEN
7012: BEGIN
7013:
7014: SELECT rule_id INTO l_rule_id
7015: FROM oie_dup_detect_rs_detail
7016: WHERE rule_set_id = l_rule_set_id AND category_code = 'All';
7017:
7018: EXCEPTION
7019: WHEN No_Data_Found THEN

Line 7032: FROM oie_dup_detect_rs_detail

7028: ELSIF l_rule_set_id IS NOT NULL THEN
7029: BEGIN
7030:
7031: SELECT rule_id INTO l_rule_id
7032: FROM oie_dup_detect_rs_detail
7033: WHERE rule_set_id = l_rule_set_id AND category_code = l_category_code;
7034:
7035: EXCEPTION
7036: WHEN No_Data_Found THEN

Line 7040: FROM oie_dup_detect_rs_detail

7036: WHEN No_Data_Found THEN
7037: BEGIN
7038:
7039: SELECT rule_id INTO l_rule_id
7040: FROM oie_dup_detect_rs_detail
7041: WHERE rule_set_id = l_rule_set_id AND category_code = 'All';
7042:
7043: EXCEPTION
7044: WHEN No_Data_Found THEN