DBA Data[Home] [Help]

APPS.QP_INT_LOADER_PUB dependencies on HZ_PARTIES

Line 1274: SELECT hz_parties.party_id

1270: FROM qp_interface_qualifiers q
1271: WHERE q.process_id = p_process_id AND q.qualifier_context = 'PARTY';
1272:
1273: --obtain the party_id
1274: SELECT hz_parties.party_id
1275: INTO x_party_id
1276: FROM hz_parties
1277: WHERE hz_parties.party_name = l_party_name;
1278:

Line 1276: FROM hz_parties

1272:
1273: --obtain the party_id
1274: SELECT hz_parties.party_id
1275: INTO x_party_id
1276: FROM hz_parties
1277: WHERE hz_parties.party_name = l_party_name;
1278:
1279: Exception
1280:

Line 1277: WHERE hz_parties.party_name = l_party_name;

1273: --obtain the party_id
1274: SELECT hz_parties.party_id
1275: INTO x_party_id
1276: FROM hz_parties
1277: WHERE hz_parties.party_name = l_party_name;
1278:
1279: Exception
1280:
1281: WHEN NO_DATA_FOUND THEN