DBA Data[Home] [Help]

APPS.OZF_AR_INTERFACE_PVT dependencies on OZF_REASON_CODES_ALL_B

Line 1073: FROM ozf_reason_codes_all_b

1069:
1070:
1071: CURSOR reason_code_csr(p_id IN NUMBER) IS
1072: SELECT reason_code
1073: FROM ozf_reason_codes_all_b
1074: WHERE reason_code_id = p_id;
1075:
1076: CURSOR invoice_reason_code_csr(p_id IN NUMBER) IS
1077: SELECT invoicing_reason_code

Line 1078: FROM ozf_reason_codes_all_b

1074: WHERE reason_code_id = p_id;
1075:
1076: CURSOR invoice_reason_code_csr(p_id IN NUMBER) IS
1077: SELECT invoicing_reason_code
1078: FROM ozf_reason_codes_all_b
1079: WHERE reason_code_id = p_id;
1080:
1081: CURSOR trx_type_gl_flag_csr(p_trx_type_id IN NUMBER) IS
1082: SELECT post_to_gl

Line 1320: -- Derive it from ozf_reason_codes_all_b

1316:
1317:
1318: /* -- Get Reason Code ----------------------------------- */
1319: -- This is optional
1320: -- Derive it from ozf_reason_codes_all_b
1321: -- reason_code should be passed only for credit memos.
1322: -- It should not be passed for debit memos.
1323: IF p_claim_rec.payment_method = 'CREDIT_MEMO' AND
1324: p_claim_rec.reason_code_id IS NOT NULL THEN