DBA Data[Home] [Help]

APPS.DPP_XLA_EVENT_PUB dependencies on OZF_CLAIM_TYPES_ALL_B

Line 392: ozf_claim_types_all_b oct

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
396: and oca.claim_type_id=oct.claim_type_id;

Line 441: ozf_claim_types_all_b oct

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
445: and oca.claim_type_id=oct.claim_type_id;