DBA Data[Home] [Help]

APPS.OZF_CLAIM_DEF_RULE_PVT dependencies on OZF_CLAIM_DEF_RULES

Line 24: FROM OZF_CLAIM_DEF_RULES

20:
21: -- CURSOR c_clam_rule ( cv_claim_class VARCHAR2, cv_source_object VARCHAR2, cv_custsetup_id NUMBER) is
22: CURSOR c_clam_rule ( cv_claim_class VARCHAR2, cv_source_object VARCHAR2) is
23: SELECT claim_type_id, reason_code_id , custom_setup_id
24: FROM OZF_CLAIM_DEF_RULES
25: WHERE CLAIM_CLASS = cv_claim_class
26: AND ( ( SOURCE_OBJECT_CLASS is null AND cv_source_object is null )
27: OR (SOURCE_OBJECT_CLASS = cv_source_object ) )
28: AND ENABLED_FLAG = 'Y';