APPS.OZF_AR_PAYMENT_PVT dependencies on OZF_SYS_PARAMETERS

Line 984: , ozf_sys_parameters sys

980:
981: CURSOR csr_batch_source(cv_set_of_books_id IN NUMBER) IS
982: SELECT name
983: FROM ra_batch_sources bs
984: , ozf_sys_parameters sys
985: WHERE sys.batch_source_id = bs.batch_source_id
986: AND sys.set_of_books_id = cv_set_of_books_id;
987:
988: CURSOR csr_reason_code(cv_reason_code_id IN NUMBER) IS

Line 1278: FROM ozf_sys_parameters

1274:
1275: CURSOR csr_sysparam_trx(cv_set_of_books_id IN NUMBER) IS
1276: --SELECT billback_trx_type_id --Modified by Padma as per 11.5.10 enhancements for system parameters.
1277: SELECT CB_TRX_TYPE_ID
1278: FROM ozf_sys_parameters
1279: WHERE set_of_books_id = cv_set_of_books_id;
1280:
1281: -- R12 Enhancements
1282: CURSOR csr_reason_code(cv_reason_code_id IN NUMBER) IS

Line 1613: FROM ozf_sys_parameters;

1609: CURSOR csr_sys_param_rec_trx IS
1610: SELECT adj_rec_trx_id
1611: , wo_rec_trx_id
1612: , neg_wo_rec_trx_id
1613: FROM ozf_sys_parameters;
1614:
1615: --Start:Bug:2781186
1616: -- Cursor to get customer reason,customer ref, reason code id
1617: CURSOR csr_get_more_root_clm_dtls (cv_claim_id IN NUMBER) IS