DBA Data[Home] [Help]

APPS.OKS_QA_DATA_INTEGRITY dependencies on OKC_CONTACTS

Line 1629: FROM Okc_contacts Contact

1625:
1626:
1627: CURSOR l_Contact_csr(p_cle_id NUMBER) IS
1628: SELECT Contact.object1_id1
1629: FROM Okc_contacts Contact
1630: , Okc_k_party_roles_b Party
1631: , okc_k_lines_b lines
1632: WHERE Contact.cpl_id = Party.id
1633: AND party.cle_id = p_cle_id

Line 1677: FROM okc_contacts contact

1673:
1674:
1675: CURSOR l_salesperson_contact IS
1676: SELECT contact.object1_id1
1677: FROM okc_contacts contact
1678: ,okc_k_party_roles_b party
1679: ,okc_k_headers_all_b header
1680: WHERE contact.cpl_id = party.id
1681: AND party.chr_id = p_chr_id