APPS.OZF_OM_VALIDATION_PVT dependencies on OZF_SYS_PARAMETERS

Line 569: FROM ozf_sys_parameters

565: WHERE claim_type_id = cv_claim_type_id;
566:
567: CURSOR csr_sys_param_rma_trx_type(cv_set_of_books_id IN NUMBER) IS
568: SELECT order_type_id
569: FROM ozf_sys_parameters
570: WHERE set_of_books_id = cv_set_of_books_id;
571:
572: BEGIN
573: IF OZF_DEBUG_HIGH_ON THEN

Line 581: -- 3. System Parameter (ozf_sys_parameters_all.order_type_id)

577: -- The following hierarchy is used to determine the default RMA transaction type,
578: -- stopping when one is found
579: -- 1. Reason (ozf_reason_codes_all_b.order_type_id)
580: -- 2. Claim Type (ozf_claim_types_all_b.order_type_id)
581: -- 3. System Parameter (ozf_sys_parameters_all.order_type_id)
582:
583: OPEN csr_reason_rma_trx_type(p_reason_code_id);
584: FETCH csr_reason_rma_trx_type INTO x_order_type_id;
585: CLOSE csr_reason_rma_trx_type;