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 838: from ozf_request_headers_all_b

834: and jtfd.domain_name='CRM_DOMAIN';
835:
836: cursor lc_get_partner_id(pc_entity_id number) is
837: select partner_id
838: from ozf_request_headers_all_b
839: where request_header_id = pc_entity_id;
840:
841: cursor lc_get_pt_cont(pc_entity_id number) is
842: select fnd.user_name

Line 844: , ozf_request_headers_all_b ref

840:
841: cursor lc_get_pt_cont(pc_entity_id number) is
842: select fnd.user_name
843: from fnd_user fnd
844: , ozf_request_headers_all_b ref
845: , jtf_rs_resource_extns jtf
846: where ref.partner_contact_id = jtf.resource_id
847: and jtf.user_id = fnd.user_id
848: and ref.request_header_id = pc_entity_id;

Line 941: FROM ozf_request_headers_all_b

937: IS
938: CURSOR csr_partner (v_request_id in number) IS
939: SELECT partner_id, request_number,
940: agreement_number, authorization_code, activity_media_id
941: FROM ozf_request_headers_all_b
942: WHERE request_header_id = v_request_id;
943:
944: CURSOR csr_activity_name (v_activity_id in number) IS
945: SELECT channel_name