APPS.JTF_MSITE_PRTY_ACCSS_MGR_PVT dependencies on HZ_PARTIES

Line 418: FROM jtf_msite_prty_accss MP, hz_parties P, ar_lookups L

414: OPEN x_msite_prty_accss_csr FOR SELECT MP.msite_prty_accss_id,
415: MP.object_version_number, MP.msite_id, MP.party_id,
416: P.party_name, P.party_type, L.meaning, MP.start_date_active,
417: MP.end_date_active
418: FROM jtf_msite_prty_accss MP, hz_parties P, ar_lookups L
419: WHERE MP.msite_id = p_msite_id
420: AND MP.party_id = P.party_id
421: AND P.party_type = 'ORGANIZATION'
422: AND L.lookup_type = 'PARTY_TYPE'

Line 546: OPEN x_party_csr FOR SELECT party_id FROM hz_parties

542: RAISE FND_API.G_EXC_ERROR;
543:
544: ELSIF (p_query_criteria = 'PARTY_NAME') THEN
545:
546: OPEN x_party_csr FOR SELECT party_id FROM hz_parties
547: WHERE party_type = 'ORGANIZATION'
548: AND UPPER(party_name) LIKE UPPER(l_criteria_value_str);
549:
550: ELSIF (p_query_criteria = 'ACCOUNT_NUMBER') THEN

Line 555: (SELECT 1 FROM hz_parties P

551:
552: OPEN x_party_csr FOR SELECT A.party_id FROM hz_cust_accounts_all A
553: WHERE UPPER(A.account_number) LIKE UPPER(l_criteria_value_str)
554: AND EXISTS
555: (SELECT 1 FROM hz_parties P
556: WHERE P.party_id = A.party_id
557: AND P.party_type = 'ORGANIZATION');
558:
559: ELSE

Line 688: 'SELECT P.party_id, P.party_name, P.party_type, L.meaning FROM hz_parties P, ar_lookups L WHERE ' ||

684: --
685: -- Construct the database sql query
686: --
687: l_db_sql :=
688: 'SELECT P.party_id, P.party_name, P.party_type, L.meaning FROM hz_parties P, ar_lookups L WHERE ' ||
689: ' P.party_type = L.lookup_code AND L.lookup_type = ''PARTY_TYPE'' AND ' ||
690: l_tmp_str;
691:
692: --