APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_SYS_PARAMETERS_ALL

Line 823: FROM ozf_sys_parameters_all ospa,

819: --Bug# 8632964 fixed by anuj & muthsubr (+)
820: CURSOR sysparam_accrual_flag_csr (p_resale_batch_id IN NUMBER)
821: IS
822: SELECT NVL(ospa.ship_debit_accrual_flag, 'F')
823: FROM ozf_sys_parameters_all ospa,
824: ozf_resale_batches_all orba
825: WHERE ospa.org_id = orba.org_id
826: AND orba.resale_batch_id = p_resale_batch_id;
827:

Line 4936: FROM ozf_sys_parameters_all

4932:
4933: --Added for bug 7030415
4934: CURSOR c_get_conversion_type IS
4935: SELECT exchange_rate_type
4936: FROM ozf_sys_parameters_all
4937: WHERE org_id = l_currOrgId;
4938:
4939: CURSOR csr_function_currency IS
4940: SELECT gs.currency_code

Line 6965: FROM ozf_sys_parameters_all

6961: AND c.cust_account_id = cv_cust_account_id;
6962:
6963: CURSOR c_get_conversion_type IS
6964: SELECT exchange_rate_type
6965: FROM ozf_sys_parameters_all
6966: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID;
6967:
6968: --POS Batch Processing by profiles by rsatyava (+)
6969: l_auto_claim_profile varchar2(1):= FND_PROFILE.value('OZF_AUTO_CLAIM_POS');

Line 7454: FROM ozf_sys_parameters_all

7450: AND c.cust_account_id = cv_cust_account_id;
7451:
7452: CURSOR c_get_conversion_type IS
7453: SELECT exchange_rate_type
7454: FROM ozf_sys_parameters_all
7455: WHERE org_id = MO_GLOBAL.GET_CURRENT_ORG_ID;
7456:
7457: --POS Batch Processing by profiles by rsatyava (+)
7458: l_auto_claim_profile varchar2(1):= FND_PROFILE.value('OZF_AUTO_CLAIM_POS');