APPS.AP_WEB_POLICY_UTILS dependencies on OIE_DUP_RULE_ASSIGNMENTS_ALL

Line 6689: OR EXISTS(SELECT 1 FROM oie_dup_rule_assignments_all rsa WHERE rsa.rule_id = rule.rule_id));

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:
6693: BEGIN

Line 6734: FROM oie_dup_rule_assignments_all

6730: FUNCTION get_dup_rs_assignment_exists(p_rule_set_id IN NUMBER) RETURN VARCHAR2 IS
6731:
6732: CURSOR assignment_rule_set_cur IS
6733: SELECT Count(rule_assignment_id) assignment_count
6734: FROM oie_dup_rule_assignments_all
6735: WHERE rule_set_id = p_rule_set_id;
6736:
6737: assignment_rule_set_rec assignment_rule_set_cur%ROWTYPE;
6738:

Line 6972: FROM oie_dup_rule_assignments_all

6968:
6969: BEGIN
6970:
6971: SELECT rule_id, rule_set_id INTO l_rule_id, l_rule_set_id
6972: FROM oie_dup_rule_assignments_all
6973: WHERE org_id = p_org_id AND Trunc(p_start_date) BETWEEN Trunc(start_date) AND Trunc(Nvl(end_date,p_start_date));
6974:
6975: EXCEPTION
6976: WHEN No_Data_Found THEN

Line 6980: FROM oie_dup_rule_assignments_all

6976: WHEN No_Data_Found THEN
6977: BEGIN
6978:
6979: SELECT rule_id, rule_set_id INTO l_rule_id, l_rule_set_id
6980: FROM oie_dup_rule_assignments_all
6981: WHERE org_id = -1 AND Trunc(p_start_date) BETWEEN Trunc(start_date) AND Trunc(Nvl(end_date,p_start_date));
6982:
6983: EXCEPTION
6984: WHEN No_Data_Found THEN

Line 7023: FROM oie_dup_rule_assignments_all

7019: WHEN No_Data_Found THEN
7020: BEGIN
7021:
7022: SELECT rule_id, rule_set_id INTO l_rule_id, l_rule_set_id
7023: FROM oie_dup_rule_assignments_all
7024: WHERE org_id = -1 AND Trunc(p_start_date) BETWEEN Trunc(start_date) AND Trunc(Nvl(end_date,p_start_date));
7025:
7026: IF l_rule_id IS NOT NULL THEN
7027: RETURN l_rule_id;