DBA Data[Home] [Help]

APPS.OZF_CLAIM_PUB dependencies on XLA_EVENT_TYPES_VL

Line 3228: FROM xla_event_types_vl

3224: l_claim_event_tbl claim_event_tbl_type;
3225:
3226: CURSOR csr_event_type_chk(cv_event_type_code IN VARCHAR2)IS
3227: SELECT event_type_code
3228: FROM xla_event_types_vl
3229: WHERE application_id = 682
3230: AND accounting_flag ='Y'
3231: AND enabled_flag ='Y'
3232: AND event_type_code = cv_event_type_code;

Line 3264: FROM xla_event_types_vl evl

3260: AND csm.org_id = c.org_id;
3261:
3262: CURSOR csr_rev_event_class(cv_event_type_code IN VARCHAR2) IS
3263: SELECT evl.event_class_code
3264: FROM xla_event_types_vl evl
3265: WHERE evl.application_id = 682
3266: AND evl.event_type_code = cv_event_type_code;
3267:
3268: CURSOR csr_chk_event_exists(cv_claim_id IN NUMBER

Line 3271: FROM xla_event_types_vl evl,

3267:
3268: CURSOR csr_chk_event_exists(cv_claim_id IN NUMBER
3269: ,cv_event_class_code IN VARCHAR2) IS
3270: SELECT 1
3271: FROM xla_event_types_vl evl,
3272: ozf_xla_claim_headers clh
3273: WHERE evl.application_id = 682
3274: AND evl.event_type_code = clh.event_type_code
3275: AND clh.claim_id = cv_claim_id