APPS.OZF_AR_PAYMENT_PVT dependencies on OZF_SYS_PARAMETERS

Line 1179: , ozf_sys_parameters sys

1175:
1176: CURSOR csr_batch_source(cv_set_of_books_id IN NUMBER) IS
1177: SELECT name
1178: FROM ra_batch_sources bs
1179: , ozf_sys_parameters sys
1180: WHERE sys.batch_source_id = bs.batch_source_id
1181: AND sys.set_of_books_id = cv_set_of_books_id;
1182:
1183: CURSOR csr_reason_code(cv_reason_code_id IN NUMBER) IS

Line 1226: FROM ozf_sys_parameters_all osp,

1222: CURSOR csr_get_interface_attr_dtls (cv_claim_id IN NUMBER) IS
1223: SELECT oc.customer_reason, oc.customer_ref_number,
1224: oc.reason_code_id, osp.post_to_gl,
1225: (SELECT SUBSTRB(name,1,30) FROM ozf_reason_codes_vl WHERE reason_code_id = oc.reason_code_id) as name
1226: FROM ozf_sys_parameters_all osp,
1227: ozf_claims_all oc
1228: WHERE
1229: NVL(osp.org_id, -99) = NVL(oc.org_id, -99)
1230: AND oc.claim_id = cv_claim_id;

Line 1564: FROM ozf_sys_parameters

1560:
1561: CURSOR csr_sysparam_trx(cv_set_of_books_id IN NUMBER) IS
1562: --SELECT billback_trx_type_id --Modified by Padma as per 11.5.10 enhancements for system parameters.
1563: SELECT CB_TRX_TYPE_ID
1564: FROM ozf_sys_parameters
1565: WHERE set_of_books_id = cv_set_of_books_id;
1566:
1567: -- R12 Enhancements
1568: CURSOR csr_reason_code(cv_reason_code_id IN NUMBER) IS

Line 1901: FROM ozf_sys_parameters;

1897: CURSOR csr_sys_param_rec_trx IS
1898: SELECT adj_rec_trx_id
1899: , wo_rec_trx_id
1900: , neg_wo_rec_trx_id
1901: FROM ozf_sys_parameters;
1902:
1903: --Start:Bug:2781186
1904: -- Cursor to get customer reason,customer ref, reason code id
1905: CURSOR csr_get_more_root_clm_dtls (cv_claim_id IN NUMBER) IS