eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.HZ_MERGE_DUP_PVT dependencies on HZ_LOCATIONS

Line 521: FROM hz_locations l

517: l.province,
518: l.postal_code,
519: ps.status,
520: ps.location_id --bug 4569674
521: FROM hz_locations l
522: , hz_party_sites ps
523: WHERE ps.party_site_id = cp_ps_id
524: AND ps.location_id = l.location_id;
525:

Line 530: l_from_country HZ_LOCATIONS.COUNTRY%TYPE;

526: CURSOR c_cust_site_check IS
527: select 1 from hz_cust_acct_sites_all where party_site_id=p_from_entity_id;
528:
529:
530: l_from_country HZ_LOCATIONS.COUNTRY%TYPE;
531: l_to_country HZ_LOCATIONS.COUNTRY%TYPE;
532: l_from_city HZ_LOCATIONS.CITY%TYPE;
533: l_to_city HZ_LOCATIONS.CITY%TYPE;
534: l_from_state HZ_LOCATIONS.STATE%TYPE;

Line 531: l_to_country HZ_LOCATIONS.COUNTRY%TYPE;

527: select 1 from hz_cust_acct_sites_all where party_site_id=p_from_entity_id;
528:
529:
530: l_from_country HZ_LOCATIONS.COUNTRY%TYPE;
531: l_to_country HZ_LOCATIONS.COUNTRY%TYPE;
532: l_from_city HZ_LOCATIONS.CITY%TYPE;
533: l_to_city HZ_LOCATIONS.CITY%TYPE;
534: l_from_state HZ_LOCATIONS.STATE%TYPE;
535: l_to_state HZ_LOCATIONS.CITY%TYPE;

Line 532: l_from_city HZ_LOCATIONS.CITY%TYPE;

528:
529:
530: l_from_country HZ_LOCATIONS.COUNTRY%TYPE;
531: l_to_country HZ_LOCATIONS.COUNTRY%TYPE;
532: l_from_city HZ_LOCATIONS.CITY%TYPE;
533: l_to_city HZ_LOCATIONS.CITY%TYPE;
534: l_from_state HZ_LOCATIONS.STATE%TYPE;
535: l_to_state HZ_LOCATIONS.CITY%TYPE;
536: l_from_county HZ_LOCATIONS.COUNTY%TYPE;

Line 533: l_to_city HZ_LOCATIONS.CITY%TYPE;

529:
530: l_from_country HZ_LOCATIONS.COUNTRY%TYPE;
531: l_to_country HZ_LOCATIONS.COUNTRY%TYPE;
532: l_from_city HZ_LOCATIONS.CITY%TYPE;
533: l_to_city HZ_LOCATIONS.CITY%TYPE;
534: l_from_state HZ_LOCATIONS.STATE%TYPE;
535: l_to_state HZ_LOCATIONS.CITY%TYPE;
536: l_from_county HZ_LOCATIONS.COUNTY%TYPE;
537: l_to_county HZ_LOCATIONS.COUNTY%TYPE;

Line 534: l_from_state HZ_LOCATIONS.STATE%TYPE;

530: l_from_country HZ_LOCATIONS.COUNTRY%TYPE;
531: l_to_country HZ_LOCATIONS.COUNTRY%TYPE;
532: l_from_city HZ_LOCATIONS.CITY%TYPE;
533: l_to_city HZ_LOCATIONS.CITY%TYPE;
534: l_from_state HZ_LOCATIONS.STATE%TYPE;
535: l_to_state HZ_LOCATIONS.CITY%TYPE;
536: l_from_county HZ_LOCATIONS.COUNTY%TYPE;
537: l_to_county HZ_LOCATIONS.COUNTY%TYPE;
538: l_from_province HZ_LOCATIONS.PROVINCE%TYPE;

Line 535: l_to_state HZ_LOCATIONS.CITY%TYPE;

531: l_to_country HZ_LOCATIONS.COUNTRY%TYPE;
532: l_from_city HZ_LOCATIONS.CITY%TYPE;
533: l_to_city HZ_LOCATIONS.CITY%TYPE;
534: l_from_state HZ_LOCATIONS.STATE%TYPE;
535: l_to_state HZ_LOCATIONS.CITY%TYPE;
536: l_from_county HZ_LOCATIONS.COUNTY%TYPE;
537: l_to_county HZ_LOCATIONS.COUNTY%TYPE;
538: l_from_province HZ_LOCATIONS.PROVINCE%TYPE;
539: l_to_province HZ_LOCATIONS.PROVINCE%TYPE;

Line 536: l_from_county HZ_LOCATIONS.COUNTY%TYPE;

532: l_from_city HZ_LOCATIONS.CITY%TYPE;
533: l_to_city HZ_LOCATIONS.CITY%TYPE;
534: l_from_state HZ_LOCATIONS.STATE%TYPE;
535: l_to_state HZ_LOCATIONS.CITY%TYPE;
536: l_from_county HZ_LOCATIONS.COUNTY%TYPE;
537: l_to_county HZ_LOCATIONS.COUNTY%TYPE;
538: l_from_province HZ_LOCATIONS.PROVINCE%TYPE;
539: l_to_province HZ_LOCATIONS.PROVINCE%TYPE;
540: l_from_postal_code HZ_LOCATIONS.postal_code%TYPE;

Line 537: l_to_county HZ_LOCATIONS.COUNTY%TYPE;

533: l_to_city HZ_LOCATIONS.CITY%TYPE;
534: l_from_state HZ_LOCATIONS.STATE%TYPE;
535: l_to_state HZ_LOCATIONS.CITY%TYPE;
536: l_from_county HZ_LOCATIONS.COUNTY%TYPE;
537: l_to_county HZ_LOCATIONS.COUNTY%TYPE;
538: l_from_province HZ_LOCATIONS.PROVINCE%TYPE;
539: l_to_province HZ_LOCATIONS.PROVINCE%TYPE;
540: l_from_postal_code HZ_LOCATIONS.postal_code%TYPE;
541: l_to_postal_code HZ_LOCATIONS.postal_code%TYPE;

Line 538: l_from_province HZ_LOCATIONS.PROVINCE%TYPE;

534: l_from_state HZ_LOCATIONS.STATE%TYPE;
535: l_to_state HZ_LOCATIONS.CITY%TYPE;
536: l_from_county HZ_LOCATIONS.COUNTY%TYPE;
537: l_to_county HZ_LOCATIONS.COUNTY%TYPE;
538: l_from_province HZ_LOCATIONS.PROVINCE%TYPE;
539: l_to_province HZ_LOCATIONS.PROVINCE%TYPE;
540: l_from_postal_code HZ_LOCATIONS.postal_code%TYPE;
541: l_to_postal_code HZ_LOCATIONS.postal_code%TYPE;
542: l_from_ps_status varchar2(1);

Line 539: l_to_province HZ_LOCATIONS.PROVINCE%TYPE;

535: l_to_state HZ_LOCATIONS.CITY%TYPE;
536: l_from_county HZ_LOCATIONS.COUNTY%TYPE;
537: l_to_county HZ_LOCATIONS.COUNTY%TYPE;
538: l_from_province HZ_LOCATIONS.PROVINCE%TYPE;
539: l_to_province HZ_LOCATIONS.PROVINCE%TYPE;
540: l_from_postal_code HZ_LOCATIONS.postal_code%TYPE;
541: l_to_postal_code HZ_LOCATIONS.postal_code%TYPE;
542: l_from_ps_status varchar2(1);
543: l_to_ps_status varchar2(1);

Line 540: l_from_postal_code HZ_LOCATIONS.postal_code%TYPE;

536: l_from_county HZ_LOCATIONS.COUNTY%TYPE;
537: l_to_county HZ_LOCATIONS.COUNTY%TYPE;
538: l_from_province HZ_LOCATIONS.PROVINCE%TYPE;
539: l_to_province HZ_LOCATIONS.PROVINCE%TYPE;
540: l_from_postal_code HZ_LOCATIONS.postal_code%TYPE;
541: l_to_postal_code HZ_LOCATIONS.postal_code%TYPE;
542: l_from_ps_status varchar2(1);
543: l_to_ps_status varchar2(1);
544: l_strucutre_id NUMBER;

Line 541: l_to_postal_code HZ_LOCATIONS.postal_code%TYPE;

537: l_to_county HZ_LOCATIONS.COUNTY%TYPE;
538: l_from_province HZ_LOCATIONS.PROVINCE%TYPE;
539: l_to_province HZ_LOCATIONS.PROVINCE%TYPE;
540: l_from_postal_code HZ_LOCATIONS.postal_code%TYPE;
541: l_to_postal_code HZ_LOCATIONS.postal_code%TYPE;
542: l_from_ps_status varchar2(1);
543: l_to_ps_status varchar2(1);
544: l_strucutre_id NUMBER;
545: l_qualifier VARCHAR2(30);

Line 965: FROM hz_locations l

961: l.province,
962: l.postal_code,
963: ps.status,
964: ps.location_id --bug 4569674
965: FROM hz_locations l
966: , hz_party_sites ps
967: WHERE ps.party_site_id = cp_ps_id
968: AND ps.location_id = l.location_id;
969:

Line 975: l_from_country HZ_LOCATIONS.COUNTRY%TYPE;

971: select 1 from hz_cust_acct_sites_all where party_site_id=p_from_entity_id;
972:
973:
974: l_count NUMBER;
975: l_from_country HZ_LOCATIONS.COUNTRY%TYPE;
976: l_to_country HZ_LOCATIONS.COUNTRY%TYPE;
977: l_from_city HZ_LOCATIONS.CITY%TYPE;
978: l_to_city HZ_LOCATIONS.CITY%TYPE;
979: l_from_state HZ_LOCATIONS.STATE%TYPE;

Line 976: l_to_country HZ_LOCATIONS.COUNTRY%TYPE;

972:
973:
974: l_count NUMBER;
975: l_from_country HZ_LOCATIONS.COUNTRY%TYPE;
976: l_to_country HZ_LOCATIONS.COUNTRY%TYPE;
977: l_from_city HZ_LOCATIONS.CITY%TYPE;
978: l_to_city HZ_LOCATIONS.CITY%TYPE;
979: l_from_state HZ_LOCATIONS.STATE%TYPE;
980: l_to_state HZ_LOCATIONS.CITY%TYPE;

Line 977: l_from_city HZ_LOCATIONS.CITY%TYPE;

973:
974: l_count NUMBER;
975: l_from_country HZ_LOCATIONS.COUNTRY%TYPE;
976: l_to_country HZ_LOCATIONS.COUNTRY%TYPE;
977: l_from_city HZ_LOCATIONS.CITY%TYPE;
978: l_to_city HZ_LOCATIONS.CITY%TYPE;
979: l_from_state HZ_LOCATIONS.STATE%TYPE;
980: l_to_state HZ_LOCATIONS.CITY%TYPE;
981: l_from_county HZ_LOCATIONS.COUNTY%TYPE;

Line 978: l_to_city HZ_LOCATIONS.CITY%TYPE;

974: l_count NUMBER;
975: l_from_country HZ_LOCATIONS.COUNTRY%TYPE;
976: l_to_country HZ_LOCATIONS.COUNTRY%TYPE;
977: l_from_city HZ_LOCATIONS.CITY%TYPE;
978: l_to_city HZ_LOCATIONS.CITY%TYPE;
979: l_from_state HZ_LOCATIONS.STATE%TYPE;
980: l_to_state HZ_LOCATIONS.CITY%TYPE;
981: l_from_county HZ_LOCATIONS.COUNTY%TYPE;
982: l_to_county HZ_LOCATIONS.COUNTY%TYPE;

Line 979: l_from_state HZ_LOCATIONS.STATE%TYPE;

975: l_from_country HZ_LOCATIONS.COUNTRY%TYPE;
976: l_to_country HZ_LOCATIONS.COUNTRY%TYPE;
977: l_from_city HZ_LOCATIONS.CITY%TYPE;
978: l_to_city HZ_LOCATIONS.CITY%TYPE;
979: l_from_state HZ_LOCATIONS.STATE%TYPE;
980: l_to_state HZ_LOCATIONS.CITY%TYPE;
981: l_from_county HZ_LOCATIONS.COUNTY%TYPE;
982: l_to_county HZ_LOCATIONS.COUNTY%TYPE;
983: l_from_province HZ_LOCATIONS.PROVINCE%TYPE;

Line 980: l_to_state HZ_LOCATIONS.CITY%TYPE;

976: l_to_country HZ_LOCATIONS.COUNTRY%TYPE;
977: l_from_city HZ_LOCATIONS.CITY%TYPE;
978: l_to_city HZ_LOCATIONS.CITY%TYPE;
979: l_from_state HZ_LOCATIONS.STATE%TYPE;
980: l_to_state HZ_LOCATIONS.CITY%TYPE;
981: l_from_county HZ_LOCATIONS.COUNTY%TYPE;
982: l_to_county HZ_LOCATIONS.COUNTY%TYPE;
983: l_from_province HZ_LOCATIONS.PROVINCE%TYPE;
984: l_to_province HZ_LOCATIONS.PROVINCE%TYPE;

Line 981: l_from_county HZ_LOCATIONS.COUNTY%TYPE;

977: l_from_city HZ_LOCATIONS.CITY%TYPE;
978: l_to_city HZ_LOCATIONS.CITY%TYPE;
979: l_from_state HZ_LOCATIONS.STATE%TYPE;
980: l_to_state HZ_LOCATIONS.CITY%TYPE;
981: l_from_county HZ_LOCATIONS.COUNTY%TYPE;
982: l_to_county HZ_LOCATIONS.COUNTY%TYPE;
983: l_from_province HZ_LOCATIONS.PROVINCE%TYPE;
984: l_to_province HZ_LOCATIONS.PROVINCE%TYPE;
985: l_from_postal_code HZ_LOCATIONS.postal_code%TYPE;

Line 982: l_to_county HZ_LOCATIONS.COUNTY%TYPE;

978: l_to_city HZ_LOCATIONS.CITY%TYPE;
979: l_from_state HZ_LOCATIONS.STATE%TYPE;
980: l_to_state HZ_LOCATIONS.CITY%TYPE;
981: l_from_county HZ_LOCATIONS.COUNTY%TYPE;
982: l_to_county HZ_LOCATIONS.COUNTY%TYPE;
983: l_from_province HZ_LOCATIONS.PROVINCE%TYPE;
984: l_to_province HZ_LOCATIONS.PROVINCE%TYPE;
985: l_from_postal_code HZ_LOCATIONS.postal_code%TYPE;
986: l_to_postal_code HZ_LOCATIONS.postal_code%TYPE;

Line 983: l_from_province HZ_LOCATIONS.PROVINCE%TYPE;

979: l_from_state HZ_LOCATIONS.STATE%TYPE;
980: l_to_state HZ_LOCATIONS.CITY%TYPE;
981: l_from_county HZ_LOCATIONS.COUNTY%TYPE;
982: l_to_county HZ_LOCATIONS.COUNTY%TYPE;
983: l_from_province HZ_LOCATIONS.PROVINCE%TYPE;
984: l_to_province HZ_LOCATIONS.PROVINCE%TYPE;
985: l_from_postal_code HZ_LOCATIONS.postal_code%TYPE;
986: l_to_postal_code HZ_LOCATIONS.postal_code%TYPE;
987: l_from_ps_status varchar2(1);

Line 984: l_to_province HZ_LOCATIONS.PROVINCE%TYPE;

980: l_to_state HZ_LOCATIONS.CITY%TYPE;
981: l_from_county HZ_LOCATIONS.COUNTY%TYPE;
982: l_to_county HZ_LOCATIONS.COUNTY%TYPE;
983: l_from_province HZ_LOCATIONS.PROVINCE%TYPE;
984: l_to_province HZ_LOCATIONS.PROVINCE%TYPE;
985: l_from_postal_code HZ_LOCATIONS.postal_code%TYPE;
986: l_to_postal_code HZ_LOCATIONS.postal_code%TYPE;
987: l_from_ps_status varchar2(1);
988: l_to_ps_status varchar2(1);

Line 985: l_from_postal_code HZ_LOCATIONS.postal_code%TYPE;

981: l_from_county HZ_LOCATIONS.COUNTY%TYPE;
982: l_to_county HZ_LOCATIONS.COUNTY%TYPE;
983: l_from_province HZ_LOCATIONS.PROVINCE%TYPE;
984: l_to_province HZ_LOCATIONS.PROVINCE%TYPE;
985: l_from_postal_code HZ_LOCATIONS.postal_code%TYPE;
986: l_to_postal_code HZ_LOCATIONS.postal_code%TYPE;
987: l_from_ps_status varchar2(1);
988: l_to_ps_status varchar2(1);
989: l_strucutre_id NUMBER;

Line 986: l_to_postal_code HZ_LOCATIONS.postal_code%TYPE;

982: l_to_county HZ_LOCATIONS.COUNTY%TYPE;
983: l_from_province HZ_LOCATIONS.PROVINCE%TYPE;
984: l_to_province HZ_LOCATIONS.PROVINCE%TYPE;
985: l_from_postal_code HZ_LOCATIONS.postal_code%TYPE;
986: l_to_postal_code HZ_LOCATIONS.postal_code%TYPE;
987: l_from_ps_status varchar2(1);
988: l_to_ps_status varchar2(1);
989: l_strucutre_id NUMBER;
990: l_qualifier VARCHAR2(30);

Line 2430: l_from_country HZ_LOCATIONS.COUNTRY%TYPE;

2426: l_org NUMBER;
2427: l_temp_from_site NUMBER;
2428: l_count NUMBER;
2429:
2430: l_from_country HZ_LOCATIONS.COUNTRY%TYPE;
2431: l_to_country HZ_LOCATIONS.COUNTRY%TYPE;
2432: l_from_city HZ_LOCATIONS.CITY%TYPE;
2433: l_to_city HZ_LOCATIONS.CITY%TYPE;
2434: l_from_state HZ_LOCATIONS.STATE%TYPE;

Line 2431: l_to_country HZ_LOCATIONS.COUNTRY%TYPE;

2427: l_temp_from_site NUMBER;
2428: l_count NUMBER;
2429:
2430: l_from_country HZ_LOCATIONS.COUNTRY%TYPE;
2431: l_to_country HZ_LOCATIONS.COUNTRY%TYPE;
2432: l_from_city HZ_LOCATIONS.CITY%TYPE;
2433: l_to_city HZ_LOCATIONS.CITY%TYPE;
2434: l_from_state HZ_LOCATIONS.STATE%TYPE;
2435: l_to_state HZ_LOCATIONS.CITY%TYPE;

Line 2432: l_from_city HZ_LOCATIONS.CITY%TYPE;

2428: l_count NUMBER;
2429:
2430: l_from_country HZ_LOCATIONS.COUNTRY%TYPE;
2431: l_to_country HZ_LOCATIONS.COUNTRY%TYPE;
2432: l_from_city HZ_LOCATIONS.CITY%TYPE;
2433: l_to_city HZ_LOCATIONS.CITY%TYPE;
2434: l_from_state HZ_LOCATIONS.STATE%TYPE;
2435: l_to_state HZ_LOCATIONS.CITY%TYPE;
2436: l_from_county HZ_LOCATIONS.COUNTY%TYPE;

Line 2433: l_to_city HZ_LOCATIONS.CITY%TYPE;

2429:
2430: l_from_country HZ_LOCATIONS.COUNTRY%TYPE;
2431: l_to_country HZ_LOCATIONS.COUNTRY%TYPE;
2432: l_from_city HZ_LOCATIONS.CITY%TYPE;
2433: l_to_city HZ_LOCATIONS.CITY%TYPE;
2434: l_from_state HZ_LOCATIONS.STATE%TYPE;
2435: l_to_state HZ_LOCATIONS.CITY%TYPE;
2436: l_from_county HZ_LOCATIONS.COUNTY%TYPE;
2437: l_to_county HZ_LOCATIONS.COUNTY%TYPE;

Line 2434: l_from_state HZ_LOCATIONS.STATE%TYPE;

2430: l_from_country HZ_LOCATIONS.COUNTRY%TYPE;
2431: l_to_country HZ_LOCATIONS.COUNTRY%TYPE;
2432: l_from_city HZ_LOCATIONS.CITY%TYPE;
2433: l_to_city HZ_LOCATIONS.CITY%TYPE;
2434: l_from_state HZ_LOCATIONS.STATE%TYPE;
2435: l_to_state HZ_LOCATIONS.CITY%TYPE;
2436: l_from_county HZ_LOCATIONS.COUNTY%TYPE;
2437: l_to_county HZ_LOCATIONS.COUNTY%TYPE;
2438: l_from_province HZ_LOCATIONS.PROVINCE%TYPE;

Line 2435: l_to_state HZ_LOCATIONS.CITY%TYPE;

2431: l_to_country HZ_LOCATIONS.COUNTRY%TYPE;
2432: l_from_city HZ_LOCATIONS.CITY%TYPE;
2433: l_to_city HZ_LOCATIONS.CITY%TYPE;
2434: l_from_state HZ_LOCATIONS.STATE%TYPE;
2435: l_to_state HZ_LOCATIONS.CITY%TYPE;
2436: l_from_county HZ_LOCATIONS.COUNTY%TYPE;
2437: l_to_county HZ_LOCATIONS.COUNTY%TYPE;
2438: l_from_province HZ_LOCATIONS.PROVINCE%TYPE;
2439: l_to_province HZ_LOCATIONS.PROVINCE%TYPE;

Line 2436: l_from_county HZ_LOCATIONS.COUNTY%TYPE;

2432: l_from_city HZ_LOCATIONS.CITY%TYPE;
2433: l_to_city HZ_LOCATIONS.CITY%TYPE;
2434: l_from_state HZ_LOCATIONS.STATE%TYPE;
2435: l_to_state HZ_LOCATIONS.CITY%TYPE;
2436: l_from_county HZ_LOCATIONS.COUNTY%TYPE;
2437: l_to_county HZ_LOCATIONS.COUNTY%TYPE;
2438: l_from_province HZ_LOCATIONS.PROVINCE%TYPE;
2439: l_to_province HZ_LOCATIONS.PROVINCE%TYPE;
2440: l_from_postal_code HZ_LOCATIONS.postal_code%TYPE;

Line 2437: l_to_county HZ_LOCATIONS.COUNTY%TYPE;

2433: l_to_city HZ_LOCATIONS.CITY%TYPE;
2434: l_from_state HZ_LOCATIONS.STATE%TYPE;
2435: l_to_state HZ_LOCATIONS.CITY%TYPE;
2436: l_from_county HZ_LOCATIONS.COUNTY%TYPE;
2437: l_to_county HZ_LOCATIONS.COUNTY%TYPE;
2438: l_from_province HZ_LOCATIONS.PROVINCE%TYPE;
2439: l_to_province HZ_LOCATIONS.PROVINCE%TYPE;
2440: l_from_postal_code HZ_LOCATIONS.postal_code%TYPE;
2441: l_to_postal_code HZ_LOCATIONS.postal_code%TYPE;

Line 2438: l_from_province HZ_LOCATIONS.PROVINCE%TYPE;

2434: l_from_state HZ_LOCATIONS.STATE%TYPE;
2435: l_to_state HZ_LOCATIONS.CITY%TYPE;
2436: l_from_county HZ_LOCATIONS.COUNTY%TYPE;
2437: l_to_county HZ_LOCATIONS.COUNTY%TYPE;
2438: l_from_province HZ_LOCATIONS.PROVINCE%TYPE;
2439: l_to_province HZ_LOCATIONS.PROVINCE%TYPE;
2440: l_from_postal_code HZ_LOCATIONS.postal_code%TYPE;
2441: l_to_postal_code HZ_LOCATIONS.postal_code%TYPE;
2442: l_structure_id NUMBER;

Line 2439: l_to_province HZ_LOCATIONS.PROVINCE%TYPE;

2435: l_to_state HZ_LOCATIONS.CITY%TYPE;
2436: l_from_county HZ_LOCATIONS.COUNTY%TYPE;
2437: l_to_county HZ_LOCATIONS.COUNTY%TYPE;
2438: l_from_province HZ_LOCATIONS.PROVINCE%TYPE;
2439: l_to_province HZ_LOCATIONS.PROVINCE%TYPE;
2440: l_from_postal_code HZ_LOCATIONS.postal_code%TYPE;
2441: l_to_postal_code HZ_LOCATIONS.postal_code%TYPE;
2442: l_structure_id NUMBER;
2443: l_qualifier VARCHAR2(30);

Line 2440: l_from_postal_code HZ_LOCATIONS.postal_code%TYPE;

2436: l_from_county HZ_LOCATIONS.COUNTY%TYPE;
2437: l_to_county HZ_LOCATIONS.COUNTY%TYPE;
2438: l_from_province HZ_LOCATIONS.PROVINCE%TYPE;
2439: l_to_province HZ_LOCATIONS.PROVINCE%TYPE;
2440: l_from_postal_code HZ_LOCATIONS.postal_code%TYPE;
2441: l_to_postal_code HZ_LOCATIONS.postal_code%TYPE;
2442: l_structure_id NUMBER;
2443: l_qualifier VARCHAR2(30);
2444: l_err_flg VARCHAR2(1) := 'N';

Line 2441: l_to_postal_code HZ_LOCATIONS.postal_code%TYPE;

2437: l_to_county HZ_LOCATIONS.COUNTY%TYPE;
2438: l_from_province HZ_LOCATIONS.PROVINCE%TYPE;
2439: l_to_province HZ_LOCATIONS.PROVINCE%TYPE;
2440: l_from_postal_code HZ_LOCATIONS.postal_code%TYPE;
2441: l_to_postal_code HZ_LOCATIONS.postal_code%TYPE;
2442: l_structure_id NUMBER;
2443: l_qualifier VARCHAR2(30);
2444: l_err_flg VARCHAR2(1) := 'N';
2445: l_cust_sites NUMBER;

Line 4638: from hz_party_sites ps, hz_locations l

4634: function get_addresses(p_to_site_id in number, get_from_addr_flag in varchar2) return varchar2
4635: is
4636: cursor get_to_addr_csr is
4637: select hz_format_pub.format_address(l.location_id,null,null,', ')
4638: from hz_party_sites ps, hz_locations l
4639: where ps.location_id = l.location_id
4640: and ps.party_site_id = p_to_site_id;
4641:
4642: cursor get_from_addr_csr is

Line 4647: hz_locations l,

4643: select hz_format_pub.format_address(l.location_id,null,null,', ')
4644: from hz_merge_parties p,
4645: hz_merge_party_details pd,
4646: hz_party_sites s,
4647: hz_locations l,
4648: hz_parties hp
4649: where p.batch_party_id = pd.batch_party_id
4650: and pd.entity_name = 'HZ_PARTY_SITES'
4651: and pd.merge_from_entity_id = s.party_site_id