[Home] [Help]
881:
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
896:
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
910: Cursor c_party_site(p_party_site_id IN NUMBER,
911: p_party_id IN NUMBER) IS
912:
913: SELECT site.party_site_id
914: FROM HZ_PARTY_SITES site,
915: HZ_PARTIES party
916: WHERE site.party_site_id = p_party_site_id
917: AND site.party_id = p_party_id
918: AND site.party_id = party.party_id
1265: and cip.instance_id = cp.instance_id
1266: and cip.party_source_table = 'HZ_PARTIES')AND
1267: (
1268: (fnd_profile.value('CS_SR_RESTRICT_IB') = 'YES'
1269: and CP.LOCATION_TYPE_CODE IN('HZ_PARTY_SITES','HZ_LOCATIONS'))
1270: or (fnd_profile.value('CS_SR_RESTRICT_IB') <> 'YES'));
1271:
1272: lv_exists_flag VARCHAR2(1) := 'N';
1273:
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
14184: AND nvl(site_use.status,'A') = 'A'
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
14197: AND nvl(site_use.status,'A') = 'A'