DBA Data[Home] [Help]

APPS.OKC_REP_QA_CHECK_PVT dependencies on OKC_REP_CONTRACT_PARTIES

Line 44: FROM okc_rep_contract_parties

40: l_index PLS_INTEGER := 0;
41:
42: CURSOR party_csr IS
43: SELECT 'X'
44: FROM okc_rep_contract_parties
45: WHERE contract_id = p_contract_id
46: and party_role_code <> l_party_role_code;
47:
48: party_rec party_csr%ROWTYPE;

Line 1337: FROM okc_rep_contract_parties

1333: contract_rec contract_csr%ROWTYPE;
1334: -- Contract parties cursor, used for validating parties
1335: CURSOR party_csr IS
1336: SELECT party_id, party_role_code
1337: FROM okc_rep_contract_parties
1338: WHERE contract_id = p_contract_id
1339: AND party_role_code <> 'INTERNAL_ORG';
1340: party_rec party_csr%ROWTYPE;
1341: -- Contract contacts cursor, used for validating contacts, contact roles