DBA Data[Home] [Help]

APPS.OZF_CLAIM_PVT dependencies on OZF_REASON_CODES_ALL_B

Line 8482: FROM ozf_reason_codes_all_b

8478: l_claim_type_org_id NUMBER;
8479:
8480: CURSOR claim_reason_org_csr(p_claim_reason_id in number) IS
8481: SELECT org_id
8482: FROM ozf_reason_codes_all_b
8483: WHERE reason_code_id = p_claim_reason_id;
8484:
8485: l_claim_reason_org_id NUMBER;
8486:

Line 8996: --FROM ozf_reason_codes_all_b

8992:
8993: -- This cursor checks whether a given reason_type is in the database
8994: --CURSOR number_of_reason_code_id_csr(p_reason_code_id in number) IS
8995: --SELECT count(reason_code_id)
8996: --FROM ozf_reason_codes_all_b
8997: --WHERE reason_code_id = p_reason_code_id;
8998:
8999: --l_number_of_reason_code_id number;
9000: