APPS.AP_WEB_POLICY_UTILS dependencies on AP_LOOKUP_CODES

Line 6789: SELECT displayed_field INTO l_rule_name FROM ap_lookup_codes

6785: RETURN NULL;
6786: END IF;
6787:
6788: IF p_rule_id = -1 THEN
6789: SELECT displayed_field INTO l_rule_name FROM ap_lookup_codes
6790: WHERE lookup_type = 'OIE_DISABLE_DUP_DETECTION' AND lookup_code = 'DISABLE_DUPLICATE_DETECTION';
6791: ELSE
6792: SELECT rule_name INTO l_rule_name FROM oie_dup_detect_rules
6793: WHERE rule_id = p_rule_id;

Line 7003: FROM ap_lookup_codes WHERE lookup_type = 'OIE_EXPENSE_CATEGORY'

6999: IF l_rule_set_id IS NOT NULL THEN
7000: BEGIN
7001:
7002: SELECT displayed_field INTO l_category_code
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