DBA Data[Home] [Help]

APPS.CS_CHARGE_DETAILS_PVT dependencies on HZ_PARTY_SITE_USES

Line 886: HZ_PARTY_SITE_USES site_use,

882: Cursor c_bill_to_party_site(p_party_site_id IN NUMBER,
883: p_party_id IN NUMBER) IS
884: SELECT site.party_site_id
885: FROM HZ_PARTY_SITES site,
886: HZ_PARTY_SITE_USES site_use,
887: HZ_PARTIES party
888: WHERE site.party_site_id = p_party_site_id
889: AND site.party_id = p_party_id
890: AND site.party_id = party.party_id

Line 901: HZ_PARTY_SITE_USES site_use,

897: Cursor c_ship_to_party_site(p_party_site_id IN NUMBER,
898: p_party_id IN NUMBER) IS
899: SELECT site.party_site_id
900: FROM HZ_PARTY_SITES site,
901: HZ_PARTY_SITE_USES site_use,
902: HZ_PARTIES party
903: WHERE site.party_site_id = p_party_site_id
904: AND site.party_id = p_party_id
905: AND site.party_id = party.party_id

Line 14179: FROM HZ_PARTY_SITE_USES site_use,

14175:
14176: CURSOR c_bill_to_party_site(P_SITE_USE_ID IN NUMBER,
14177: P_PARTY_ID IN NUMBER) IS
14178: SELECT site_use.party_site_id
14179: FROM HZ_PARTY_SITE_USES site_use,
14180: HZ_PARTY_SITES site,
14181: HZ_PARTIES party
14182: WHERE site_use.party_site_use_id = p_site_use_id
14183: AND party.party_id = p_party_id

Line 14192: FROM HZ_PARTY_SITE_USES site_use,

14188:
14189: CURSOR c_ship_to_party_site(p_site_use_id IN NUMBER,
14190: p_party_id IN NUMBER) IS
14191: SELECT site_use.party_site_id
14192: FROM HZ_PARTY_SITE_USES site_use,
14193: HZ_PARTY_SITES site,
14194: HZ_PARTIES party
14195: WHERE site_use.party_site_use_id = p_site_use_id
14196: AND party.party_id = p_party_id