APPS.AS_SALES_LEAD_OWNER dependencies on HZ_PARTY_SITES

Line 1177: FROM AS_SALES_LEADS LEAD, HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, AS_SALES_LEAD_OWNERS ASO

1173:
1174:
1175: CURSOR lc_lead_owners_postal(pc_lead_id NUMBER) IS
1176: SELECT aso.cm_resource_id, aso.owner_flag
1177: FROM AS_SALES_LEADS LEAD, HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, AS_SALES_LEAD_OWNERS ASO
1178: WHERE LEAD.SALES_LEAD_ID = pc_lead_id AND LEAD.ADDRESS_ID = PS.PARTY_SITE_ID(+)
1179: AND PS.LOCATION_ID = LOC.LOCATION_ID(+) AND ASO.COUNTRY = LOC.COUNTRY
1180: AND LOC.POSTAL_CODE BETWEEN ASO.FROM_POSTAL_CODE AND ASO.TO_POSTAL_CODE
1181: AND LEAD.REFERRAL_TYPE = ASO.REFERRAL_TYPE;

Line 1185: FROM AS_SALES_LEADS LEAD, HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, AS_SALES_LEAD_OWNERS ASO

1181: AND LEAD.REFERRAL_TYPE = ASO.REFERRAL_TYPE;
1182:
1183: CURSOR lc_lead_owners_country(pc_lead_id NUMBER) IS
1184: SELECT aso.cm_resource_id, aso.owner_flag
1185: FROM AS_SALES_LEADS LEAD, HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, AS_SALES_LEAD_OWNERS ASO
1186: WHERE LEAD.SALES_LEAD_ID = pc_lead_id AND LEAD.ADDRESS_ID = PS.PARTY_SITE_ID(+)
1187: AND PS.LOCATION_ID = LOC.LOCATION_ID(+) AND ASO.COUNTRY = LOC.COUNTRY
1188: -- AND LOC.POSTAL_CODE BETWEEN ASO.FROM_POSTAL_CODE AND ASO.TO_POSTAL_CODE);
1189: AND LEAD.REFERRAL_TYPE = ASO.REFERRAL_TYPE;

Line 1363: FROM AS_SALES_LEADS LEAD, HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, AS_SALES_LEAD_OWNERS ASO

1359:
1360:
1361: CURSOR lc_lead_owners_postal(pc_lead_id NUMBER) IS
1362: SELECT aso.cm_resource_id, aso.owner_flag
1363: FROM AS_SALES_LEADS LEAD, HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, AS_SALES_LEAD_OWNERS ASO
1364: WHERE LEAD.SALES_LEAD_ID = pc_lead_id AND LEAD.ADDRESS_ID = PS.PARTY_SITE_ID(+)
1365: AND PS.LOCATION_ID = LOC.LOCATION_ID(+) AND ASO.COUNTRY = LOC.COUNTRY
1366: AND LOC.POSTAL_CODE BETWEEN ASO.FROM_POSTAL_CODE AND ASO.TO_POSTAL_CODE
1367: AND ASO.CATEGORY = 'IMMATURED'

Line 1372: FROM AS_SALES_LEADS LEAD, HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, AS_SALES_LEAD_OWNERS ASO

1368: AND ASO.OWNER_FLAG = 'Y';
1369:
1370: CURSOR lc_lead_owners_country(pc_lead_id NUMBER) IS
1371: SELECT aso.cm_resource_id, aso.owner_flag
1372: FROM AS_SALES_LEADS LEAD, HZ_PARTY_SITES PS, HZ_LOCATIONS LOC, AS_SALES_LEAD_OWNERS ASO
1373: WHERE LEAD.SALES_LEAD_ID = pc_lead_id AND LEAD.ADDRESS_ID = PS.PARTY_SITE_ID(+)
1374: AND PS.LOCATION_ID = LOC.LOCATION_ID(+) AND ASO.COUNTRY = LOC.COUNTRY
1375: -- AND LOC.POSTAL_CODE BETWEEN ASO.FROM_POSTAL_CODE AND ASO.TO_POSTAL_CODE);
1376: AND ASO.CATEGORY = 'IMMATURED'