APPS.DPP_MIG_ADJ_PARA_APPROVAL_PVT dependencies on OZF_PROCESS_SETUP_ALL

Line 330: FROM ozf_process_setup_all

326: --Cursor to check if the execution process setup exists at the system parameters
327: CURSOR get_process_setup_cnt_csr (p_org_id NUMBER)
328: IS
329: SELECT COUNT(1)
330: FROM ozf_process_setup_all
331: WHERE nvl(supp_trade_profile_id,0) = 0
332: AND enabled_flag = 'Y'
333: AND org_id = p_org_id;
334:

Line 502: FROM OZF_PROCESS_SETUP_ALL

498: --Cursor to check if the execution process setup is available either at Supplier Trade Profile or System Parameters
499: CURSOR get_process_setup_cnt_csr (p_supp_trade_profile_id NUMBER, p_org_id NUMBER)
500: IS
501: SELECT COUNT(1)
502: FROM OZF_PROCESS_SETUP_ALL
503: WHERE nvl(supp_trade_profile_id,0) = nvl(p_supp_trade_profile_id,0)
504: AND enabled_flag = 'Y'
505: AND org_id = p_org_id;
506:

Line 512: ozf_process_setup_all opsa

508: CURSOR get_process_codes_csr (p_supp_trd_prf_id NUMBER, p_org_id NUMBER)
509: IS
510: SELECT dppl.lookup_code
511: FROM dpp_lookups dppl,
512: ozf_process_setup_all opsa
513: WHERE dppl.lookup_type = 'DPP_EXECUTION_PROCESSES'
514: AND dppl.tag is not null
515: AND nvl(opsa.supp_trade_profile_id,0) = nvl(p_supp_trd_prf_id,0)
516: AND opsa.enabled_flag = 'Y'