DBA Data[Home] [Help]

APPS.OKC_REP_QA_CHECK_PVT dependencies on OKC_REP_CONTRACTS_ALL

Line 1331: FROM okc_rep_contracts_all

1327: l_api_name CONSTANT VARCHAR2(30) := 'validate_repository_for_qa';
1328: -- Contract cursor
1329: CURSOR contract_csr IS
1330: SELECT contract_effective_date
1331: FROM okc_rep_contracts_all
1332: WHERE contract_id = p_contract_id;
1333: contract_rec contract_csr%ROWTYPE;
1334: -- Contract parties cursor, used for validating parties
1335: CURSOR party_csr IS

Line 1704: FROM okc_rep_contracts_all

1700: l_warning_found Boolean := FALSE;
1701:
1702: CURSOR contract_csr IS
1703: SELECT contract_type, contract_expiration_date, contract_effective_date
1704: FROM okc_rep_contracts_all
1705: WHERE contract_id = p_contract_id;
1706:
1707: contract_rec contract_csr%ROWTYPE;
1708: