APPS.DPP_XLA_EVENT_PUB dependencies on OZF_SYS_PARAMETERS_ALL

Line 324: FROM ozf_sys_parameters_all

320: BEGIN
321: x_pp_accrual_ccid:=NULL;
322: SELECT gl_pp_accrual_acct
323: INTO x_pp_accrual_ccid
324: FROM ozf_sys_parameters_all
325: where org_id=p_org_id;
326: RETURN(x_pp_accrual_ccid);
327:
328:

Line 355: FROM ozf_sys_parameters_all

351: EXCEPTION WHEN NO_DATA_FOUND THEN
352: BEGIN
353: SELECT gl_cost_adjustment_acct
354: INTO x_cost_adj_ccid
355: FROM ozf_sys_parameters_all
356: where org_id=p_org_id;
357: RETURN(x_cost_adj_ccid);
358: EXCEPTION WHEN NO_DATA_FOUND THEN
359: RETURN(-1);

Line 386: FROM ozf_sys_parameters_all osp

382: EXCEPTION WHEN NO_DATA_FOUND THEN
383: BEGIN
384: SELECT GL_ID_DED_CLEARING
385: INTO x_ap_clearing_ccid
386: FROM ozf_sys_parameters_all osp
387: where osp.org_id=p_org_id;
388: RETURN(x_ap_clearing_ccid);
389: EXCEPTION WHEN NO_DATA_FOUND THEN
390: RETURN(-1);

Line 418: FROM ozf_sys_parameters_all osp

414: EXCEPTION WHEN NO_DATA_FOUND THEN
415: BEGIN
416: SELECT GL_ID_DED_ADJ_CLEARING
417: INTO x_ar_clearing_ccid
418: FROM ozf_sys_parameters_all osp
419: where osp.org_id=p_org_id;
420: RETURN(x_ar_clearing_ccid);
421: EXCEPTION WHEN NO_DATA_FOUND THEN
422: RETURN(-1);

Line 453: FROM ozf_sys_parameters_all

449: EXCEPTION WHEN NO_DATA_FOUND THEN
450: BEGIN
451: SELECT gl_contra_liability_acct
452: INTO x_contra_liab_ccid
453: FROM ozf_sys_parameters_all
454: where org_id=p_org_id;
455: return(x_contra_liab_ccid);
456: EXCEPTION WHEN NO_DATA_FOUND THEN
457: x_contra_liab_ccid:=-1;