APPS.DPP_XLA_EVENT_PUB dependencies on OZF_CLAIMS_ALL

Line 391: FROM ozf_claims_all oca,

387: BEGIN
388: x_ap_clearing_ccid:=NULL;
389: SELECT NVL(GL_ID_DED_CLEARING,-1)
390: INTO x_ap_clearing_ccid
391: FROM ozf_claims_all oca,
392: ozf_claim_types_all_b oct
393: where oca.org_id=p_org_id
394: and oct.org_id=p_org_id
395: and oca.claim_id=p_claim_id

Line 440: FROM ozf_claims_all oca,

436: x_ar_clearing_ccid:=NULL;
437:
438: SELECT NVL(GL_ID_DED_ADJ_CLEARING,-1)
439: INTO x_ar_clearing_ccid
440: FROM ozf_claims_all oca,
441: ozf_claim_types_all_b oct
442: where oca.org_id=p_org_id
443: and oct.org_id=p_org_id
444: and oca.claim_id=p_claim_id