DBA Data[Home] [Help]

APPS.OKC_REP_UTIL_PVT dependencies on OKC_RESP_PARTIES_B

Line 1322: FROM okc_resp_parties_b

1318: AND document_type_class = 'REPOSITORY';
1319:
1320: CURSOR party_role_valid_csr IS
1321: SELECT 1
1322: FROM okc_resp_parties_b
1323: WHERE resp_party_code = p_party_role_code
1324: AND intent = p_intent
1325: AND document_type_class = 'REPOSITORY';
1326:

Line 3760: --FROM OKC_RESP_PARTIES_B RESP_PARTIES,

3756: l_int_party_name OKC_REP_IMP_PARTIES_T.PARTY_NAME_TXT%TYPE;
3757:
3758: --CURSOR PARTY_INTENT_CSR (p_contract_type VARCHAR2, p_party_role_code VARCHAR2) IS
3759: --SELECT INTERNAL_EXTERNAL_FLAG
3760: --FROM OKC_RESP_PARTIES_B RESP_PARTIES,
3761: --OKC_BUS_DOC_TYPES_B DOC_TYPES
3762: --WHERE RESP_PARTIES.RESP_PARTY_CODE = p_party_role_code
3763: --AND RESP_PARTIES.DOCUMENT_TYPE_CLASS = 'REPOSITORY'
3764: --AND DOC_TYPES.INTENT = RESP_PARTIES.INTENT