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.

APPS.HZ_MERGE_DUP_PVT dependencies on HZ_LOCATIONS

Line 520: FROM hz_locations l

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

Line 529: l_from_country HZ_LOCATIONS.COUNTRY%TYPE;

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

Line 530: l_to_country HZ_LOCATIONS.COUNTRY%TYPE;

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

Line 531: l_from_city HZ_LOCATIONS.CITY%TYPE;

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

Line 532: l_to_city HZ_LOCATIONS.CITY%TYPE;

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

Line 533: l_from_state HZ_LOCATIONS.STATE%TYPE;

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

Line 534: l_to_state HZ_LOCATIONS.CITY%TYPE;

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

Line 535: l_from_county HZ_LOCATIONS.COUNTY%TYPE;

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

Line 536: l_to_county HZ_LOCATIONS.COUNTY%TYPE;

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

Line 537: l_from_province HZ_LOCATIONS.PROVINCE%TYPE;

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

Line 538: l_to_province HZ_LOCATIONS.PROVINCE%TYPE;

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

Line 539: l_from_postal_code HZ_LOCATIONS.postal_code%TYPE;

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

Line 540: l_to_postal_code HZ_LOCATIONS.postal_code%TYPE;

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

Line 964: FROM hz_locations l

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

Line 974: l_from_country HZ_LOCATIONS.COUNTRY%TYPE;

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

Line 975: l_to_country HZ_LOCATIONS.COUNTRY%TYPE;

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

Line 976: l_from_city HZ_LOCATIONS.CITY%TYPE;

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

Line 977: l_to_city HZ_LOCATIONS.CITY%TYPE;

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

Line 978: l_from_state HZ_LOCATIONS.STATE%TYPE;

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

Line 979: l_to_state HZ_LOCATIONS.CITY%TYPE;

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

Line 980: l_from_county HZ_LOCATIONS.COUNTY%TYPE;

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

Line 981: l_to_county HZ_LOCATIONS.COUNTY%TYPE;

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

Line 982: l_from_province HZ_LOCATIONS.PROVINCE%TYPE;

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

Line 983: l_to_province HZ_LOCATIONS.PROVINCE%TYPE;

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

Line 984: l_from_postal_code HZ_LOCATIONS.postal_code%TYPE;

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

Line 985: l_to_postal_code HZ_LOCATIONS.postal_code%TYPE;

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

Line 2429: l_from_country HZ_LOCATIONS.COUNTRY%TYPE;

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

Line 2430: l_to_country HZ_LOCATIONS.COUNTRY%TYPE;

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

Line 2431: l_from_city HZ_LOCATIONS.CITY%TYPE;

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

Line 2432: l_to_city HZ_LOCATIONS.CITY%TYPE;

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

Line 2433: l_from_state HZ_LOCATIONS.STATE%TYPE;

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

Line 2434: l_to_state HZ_LOCATIONS.CITY%TYPE;

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

Line 2435: l_from_county HZ_LOCATIONS.COUNTY%TYPE;

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

Line 2436: l_to_county HZ_LOCATIONS.COUNTY%TYPE;

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

Line 2437: l_from_province HZ_LOCATIONS.PROVINCE%TYPE;

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

Line 2438: l_to_province HZ_LOCATIONS.PROVINCE%TYPE;

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

Line 2439: l_from_postal_code HZ_LOCATIONS.postal_code%TYPE;

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

Line 2440: l_to_postal_code HZ_LOCATIONS.postal_code%TYPE;

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

Line 4635: from hz_party_sites ps, hz_locations l

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

Line 4644: hz_locations l,

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