3929: p_agreement_number okc_k_headers_v.contract_number%TYPE,
3930: p_auth_org_id okc_k_headers_v.authoring_org_id%TYPE
3931: ) IS
3932: SELECT id
3933: FROM okc_k_headers_all_b
3934: WHERE ((contract_number = p_agreement_number
3935: AND
3936: p_agreement_number IS NOT NULL
3937: )
4007: p_agreement_id okc_k_headers_v.id%TYPE,
4008: p_agreement_number okc_k_headers_v.contract_number%TYPE
4009: ) IS
4010: SELECT id
4011: FROM okc_k_headers_all_b
4012: WHERE ((contract_number = p_agreement_number
4013: AND
4014: p_agreement_number IS NOT NULL
4015: )