3761: p_agreement_number okc_k_headers_v.contract_number%TYPE,
3762: p_auth_org_id okc_k_headers_v.authoring_org_id%TYPE
3763: ) IS
3764: SELECT id
3765: FROM okc_k_headers_all_b
3766: WHERE ((contract_number = p_agreement_number
3767: AND
3768: p_agreement_number IS NOT NULL
3769: )
3839: p_agreement_id okc_k_headers_v.id%TYPE,
3840: p_agreement_number okc_k_headers_v.contract_number%TYPE
3841: ) IS
3842: SELECT id
3843: FROM okc_k_headers_all_b
3844: WHERE ((contract_number = p_agreement_number
3845: AND
3846: p_agreement_number IS NOT NULL
3847: )