DBA Data[Home] [Help]

APPS.INL_INTERFACE_PVT dependencies on HZ_PARTY_USG_ASSIGNMENTS

Line 1389: FROM hz_party_usg_assignments ua

1385: SELECT
1386: party_id,
1387: party_number,
1388: (SELECT COUNT(1)
1389: FROM hz_party_usg_assignments ua
1390: WHERE ua.party_id = hp.party_id
1391: AND(UPPER(hp.party_type)
1392: IN (SELECT
1393: UPPER(cfopt.party_type_code)

Line 1406: hz_party_usg_assignments ua,

1402: (SELECT
1403: COUNT(1)
1404: FROM
1405: hz_party_usages_vl pu,
1406: hz_party_usg_assignments ua,
1407: hz_parties hp1
1408: WHERE
1409: pu.party_usage_code = ua.party_usage_code
1410: AND ua.party_id = hp1.party_id