APPS.OZF_REQUEST_STATUS_PVT dependencies on OZF_REQUEST_HEADERS_ALL_B

Line 58: FROM ozf_request_headers_all_b

54: l_approval_rec OZF_APPROVAL_PVT.approval_rec_type;
55:
56: CURSOR csr_benefit (p_object_id in number) IS
57: SELECT benefit_id, partner_id
58: FROM ozf_request_headers_all_b
59: WHERE request_header_id = p_object_id;
60:
61: BEGIN
62: -- Standard begin of API savepoint

Line 851: from ozf_request_headers_all_b

847: and jtfd.domain_name='CRM_DOMAIN';
848:
849: cursor lc_get_partner_id(pc_entity_id number) is
850: select partner_id
851: from ozf_request_headers_all_b
852: where request_header_id = pc_entity_id;
853:
854: cursor lc_get_pt_cont(pc_entity_id number) is
855: select fnd.user_name

Line 857: , ozf_request_headers_all_b ref

853:
854: cursor lc_get_pt_cont(pc_entity_id number) is
855: select fnd.user_name
856: from fnd_user fnd
857: , ozf_request_headers_all_b ref
858: , jtf_rs_resource_extns jtf
859: where ref.partner_contact_id = jtf.resource_id
860: and jtf.user_id = fnd.user_id
861: and ref.request_header_id = pc_entity_id;

Line 954: FROM ozf_request_headers_all_b

950: IS
951: CURSOR csr_partner (v_request_id in number) IS
952: SELECT partner_id, request_number,
953: agreement_number, authorization_code, activity_media_id
954: FROM ozf_request_headers_all_b
955: WHERE request_header_id = v_request_id;
956:
957: CURSOR csr_activity_name (v_activity_id in number) IS
958: SELECT channel_name