APPS.CS_CHARGE_DETAILS_PVT dependencies on HZ_PARTY_SITES

Line 922: FROM HZ_PARTY_SITES site,

918:
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

Line 937: FROM HZ_PARTY_SITES site,

933:
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

Line 951: FROM HZ_PARTY_SITES site,

947: Cursor c_party_site(p_party_site_id IN NUMBER,
948: p_party_id IN NUMBER) IS
949:
950: SELECT site.party_site_id
951: FROM HZ_PARTY_SITES site,
952: HZ_PARTIES party
953: WHERE site.party_site_id = p_party_site_id
954: AND site.party_id = p_party_id
955: AND site.party_id = party.party_id

Line 1308: and CP.LOCATION_TYPE_CODE IN('HZ_PARTY_SITES','HZ_LOCATIONS'))

1304: and cip.instance_id = cp.instance_id
1305: and cip.party_source_table = 'HZ_PARTIES')AND
1306: (
1307: (fnd_profile.value('CS_SR_RESTRICT_IB') = 'YES'
1308: and CP.LOCATION_TYPE_CODE IN('HZ_PARTY_SITES','HZ_LOCATIONS'))
1309: or (fnd_profile.value('CS_SR_RESTRICT_IB') <> 'YES'));
1310:
1311: lv_exists_flag VARCHAR2(1) := 'N';
1312:

Line 3870: from hz_party_sites

3866: l_return_type Varchar2(2);
3867:
3868: Cursor c_location_id(p_party_site_id Number) is
3869: Select location_id
3870: from hz_party_sites
3871: where party_site_id = p_party_site_id;
3872:
3873: l_location_id Number;
3874: l_shipping_method_found varchar2(1) := 'N';

Line 15717: HZ_PARTY_SITES site,

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
15721: AND nvl(site_use.status,'A') = 'A'

Line 15730: HZ_PARTY_SITES site,

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
15734: AND nvl(site_use.status,'A') = 'A'