DBA Data[Home] [Help]

APPS.CS_CHARGE_DETAILS_PVT dependencies on HZ_PARTY_SITE_USES

Line 923: HZ_PARTY_SITE_USES site_use,

919: Cursor c_bill_to_party_site(p_party_site_id IN NUMBER,
920: p_party_id IN NUMBER) IS
921: SELECT site.party_site_id
922: FROM HZ_PARTY_SITES site,
923: HZ_PARTY_SITE_USES site_use,
924: HZ_PARTIES party
925: WHERE site.party_site_id = p_party_site_id
926: AND site.party_id = p_party_id
927: AND site.party_id = party.party_id

Line 938: HZ_PARTY_SITE_USES site_use,

934: Cursor c_ship_to_party_site(p_party_site_id IN NUMBER,
935: p_party_id IN NUMBER) IS
936: SELECT site.party_site_id
937: FROM HZ_PARTY_SITES site,
938: HZ_PARTY_SITE_USES site_use,
939: HZ_PARTIES party
940: WHERE site.party_site_id = p_party_site_id
941: AND site.party_id = p_party_id
942: AND site.party_id = party.party_id

Line 15716: FROM HZ_PARTY_SITE_USES site_use,

15712:
15713: CURSOR c_bill_to_party_site(P_SITE_USE_ID IN NUMBER,
15714: P_PARTY_ID IN NUMBER) IS
15715: SELECT site_use.party_site_id
15716: FROM HZ_PARTY_SITE_USES site_use,
15717: HZ_PARTY_SITES site,
15718: HZ_PARTIES party
15719: WHERE site_use.party_site_use_id = p_site_use_id
15720: AND party.party_id = p_party_id

Line 15729: FROM HZ_PARTY_SITE_USES site_use,

15725:
15726: CURSOR c_ship_to_party_site(p_site_use_id IN NUMBER,
15727: p_party_id IN NUMBER) IS
15728: SELECT site_use.party_site_id
15729: FROM HZ_PARTY_SITE_USES site_use,
15730: HZ_PARTY_SITES site,
15731: HZ_PARTIES party
15732: WHERE site_use.party_site_use_id = p_site_use_id
15733: AND party.party_id = p_party_id