DBA Data[Home] [Help]

APPS.OZF_AR_INTERFACE_PVT dependencies on OZF_REASON_CODES_ALL_B

Line 1069: FROM ozf_reason_codes_all_b

1065:
1066:
1067: CURSOR reason_code_csr(p_id IN NUMBER) IS
1068: SELECT reason_code
1069: FROM ozf_reason_codes_all_b
1070: WHERE reason_code_id = p_id;
1071:
1072: CURSOR invoice_reason_code_csr(p_id IN NUMBER) IS
1073: SELECT invoicing_reason_code

Line 1074: FROM ozf_reason_codes_all_b

1070: WHERE reason_code_id = p_id;
1071:
1072: CURSOR invoice_reason_code_csr(p_id IN NUMBER) IS
1073: SELECT invoicing_reason_code
1074: FROM ozf_reason_codes_all_b
1075: WHERE reason_code_id = p_id;
1076:
1077: CURSOR trx_type_gl_flag_csr(p_trx_type_id IN NUMBER) IS
1078: SELECT post_to_gl

Line 1314: -- Derive it from ozf_reason_codes_all_b

1310:
1311:
1312: /* -- Get Reason Code ----------------------------------- */
1313: -- This is optional
1314: -- Derive it from ozf_reason_codes_all_b
1315: -- reason_code should be passed only for credit memos.
1316: -- It should not be passed for debit memos.
1317: IF p_claim_rec.payment_method = 'CREDIT_MEMO' AND
1318: p_claim_rec.reason_code_id IS NOT NULL THEN