DBA Data[Home] [Help]

APPS.IBY_DISBURSEMENT_COMP_PUB dependencies on HZ_PARTY_SITES

Line 725: FROM HZ_PARTY_SITES sites,

721: CURSOR payeesite_country_csr(p_payee_id IN NUMBER,
722: p_payee_site_id IN NUMBER)
723: IS
724: SELECT locs.country
725: FROM HZ_PARTY_SITES sites,
726: HZ_LOCATIONS locs
727: WHERE sites.party_id = p_payee_id
728: AND sites.party_site_id = p_payee_site_id
729: AND sites.location_id = locs.location_id;

Line 3192: FROM HZ_PARTY_SITES sites,

3188: CURSOR payeesite_country_csr(p_payee_id IN NUMBER,
3189: p_payee_site_id IN NUMBER)
3190: IS
3191: SELECT locs.country
3192: FROM HZ_PARTY_SITES sites,
3193: HZ_LOCATIONS locs
3194: WHERE sites.party_id = p_payee_id
3195: AND sites.party_site_id = p_payee_site_id
3196: AND sites.location_id = locs.location_id;