APPS.OZF_CLAIM_PUB dependencies on OZF_XLA_CLAIM_HEADERS

Line 3251: FROM ozf_xla_claim_headers

3247:
3248: CURSOR csr_claim_dup_chk(cv_claim_id IN NUMBER)IS
3249: SELECT count(event_id),
3250: NVL(reversal_flag,'N')
3251: FROM ozf_xla_claim_headers
3252: WHERE claim_id = cv_claim_id
3253: GROUP BY reversal_flag;
3254:
3255: CURSOR taxfor_csr (p_claim_id IN NUMBER)IS

Line 3272: ozf_xla_claim_headers clh

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
3276: AND evl.event_class_code = cv_event_class_code;

Line 3520: 1. One entry in ozf_xla_claim_headers table and reversal flag is Y

3516:
3517: --//Duplicate events check
3518: /* ===============================================================
3519: Event can be created when
3520: 1. One entry in ozf_xla_claim_headers table and reversal flag is Y
3521: 2.Even number of entries in ozf_xla_claim_headers for the same claim_idand reversal flag is equel to Y
3522:
3523: =================================================================*/
3524: OPEN csr_claim_dup_chk(p_claim_id);

Line 3521: 2.Even number of entries in ozf_xla_claim_headers for the same claim_idand reversal flag is equel to Y

3517: --//Duplicate events check
3518: /* ===============================================================
3519: Event can be created when
3520: 1. One entry in ozf_xla_claim_headers table and reversal flag is Y
3521: 2.Even number of entries in ozf_xla_claim_headers for the same claim_idand reversal flag is equel to Y
3522:
3523: =================================================================*/
3524: OPEN csr_claim_dup_chk(p_claim_id);
3525: FETCH csr_claim_dup_chk BULK COLLECT INTO l_claim_event_tbl;