DBA Data[Home] [Help]

APPS.IBY_DISBURSEMENT_COMP_PUB dependencies on HZ_LOCATIONS

Line 645: HZ_LOCATIONS locs

641: p_payee_site_id IN NUMBER)
642: IS
643: SELECT locs.country
644: FROM HZ_PARTY_SITES sites,
645: HZ_LOCATIONS locs
646: WHERE sites.party_id = p_payee_id
647: AND sites.party_site_id = p_payee_site_id
648: AND sites.location_id = locs.location_id;
649:

Line 2833: HZ_LOCATIONS locs

2829: p_payee_site_id IN NUMBER)
2830: IS
2831: SELECT locs.country
2832: FROM HZ_PARTY_SITES sites,
2833: HZ_LOCATIONS locs
2834: WHERE sites.party_id = p_payee_id
2835: AND sites.party_site_id = p_payee_site_id
2836: AND sites.location_id = locs.location_id;
2837: