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 356: FROM ozf_sys_parameters_all

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

Line 370: FROM ozf_sys_parameters_all

366: EXCEPTION WHEN NO_DATA_FOUND THEN
367: BEGIN
368: SELECT gl_cost_adjustment_acct
369: INTO x_cost_adj_ccid
370: FROM ozf_sys_parameters_all
371: where org_id=p_org_id;
372:
373: RETURN(x_cost_adj_ccid);
374: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 403: FROM ozf_sys_parameters_all osp

399: IF(x_ap_clearing_ccid = -1) THEN
400: BEGIN
401: SELECT GL_ID_DED_CLEARING
402: INTO x_ap_clearing_ccid
403: FROM ozf_sys_parameters_all osp
404: where osp.org_id=p_org_id;
405:
406: EXCEPTION WHEN NO_DATA_FOUND THEN
407: RETURN(-1);

Line 417: FROM ozf_sys_parameters_all osp

413: EXCEPTION WHEN NO_DATA_FOUND THEN
414: BEGIN
415: SELECT GL_ID_DED_CLEARING
416: INTO x_ap_clearing_ccid
417: FROM ozf_sys_parameters_all osp
418: where osp.org_id=p_org_id;
419:
420: RETURN(x_ap_clearing_ccid);
421:

Line 452: FROM ozf_sys_parameters_all osp

448: IF(x_ar_clearing_ccid = -1) THEN
449: BEGIN
450: SELECT NVL(GL_ID_DED_ADJ_CLEARING,-1)
451: INTO x_ar_clearing_ccid
452: FROM ozf_sys_parameters_all osp
453: where osp.org_id=p_org_id;
454:
455: EXCEPTION WHEN NO_DATA_FOUND THEN
456: RETURN(-1);

Line 466: FROM ozf_sys_parameters_all osp

462: EXCEPTION WHEN NO_DATA_FOUND THEN
463: BEGIN
464: SELECT GL_ID_DED_ADJ_CLEARING
465: INTO x_ar_clearing_ccid
466: FROM ozf_sys_parameters_all osp
467: where osp.org_id=p_org_id;
468:
469: RETURN(x_ar_clearing_ccid);
470:

Line 503: FROM ozf_sys_parameters_all

499: IF (x_contra_liab_ccid = -1) THEN
500: BEGIN
501: SELECT gl_contra_liability_acct
502: INTO x_contra_liab_ccid
503: FROM ozf_sys_parameters_all
504: where org_id=p_org_id;
505:
506: EXCEPTION WHEN NO_DATA_FOUND THEN
507: x_contra_liab_ccid:=-1;

Line 519: FROM ozf_sys_parameters_all

515: EXCEPTION WHEN NO_DATA_FOUND THEN
516: BEGIN
517: SELECT gl_contra_liability_acct
518: INTO x_contra_liab_ccid
519: FROM ozf_sys_parameters_all
520: where org_id=p_org_id;
521:
522: return(x_contra_liab_ccid);
523: