APPS.IGS_FI_PRC_APINT dependencies on HZ_LOCATIONS

Line 835: CURSOR c_hz_loc_addr(cp_n_location_id hz_locations.location_id%TYPE) IS

831: person_last_name
832: FROM hz_parties
833: WHERE party_id = cp_n_party_id;
834:
835: CURSOR c_hz_loc_addr(cp_n_location_id hz_locations.location_id%TYPE) IS
836: SELECT substr (address1,1,35) address1,
837: substr (address2,1,35) address2,
838: substr (address3,1,35) address3,
839: substr (address4,1,35) address4,

Line 846: FROM hz_locations

842: substr (postal_code,1,20) postal_code,
843: substr (province,1,25) province,
844: substr (county,1,25) county,
845: substr (country,1,25) country
846: FROM hz_locations
847: WHERE location_id = cp_n_location_id;
848:
849: l_c_hz_party c_hz_party%ROWTYPE;
850: l_c_prty_rel c_prty_rel%ROWTYPE;

Line 855: l_n_location_id hz_locations.location_id%TYPE;

851: l_b_prty_rel BOOLEAN := TRUE;
852: l_c_hz_loc_addr c_hz_loc_addr%ROWTYPE;
853:
854: l_v_var VARCHAR2(1);
855: l_n_location_id hz_locations.location_id%TYPE;
856:
857: l_b_addr_stat BOOLEAN := TRUE;
858: l_b_vendor_site BOOLEAN := TRUE;
859: l_b_status BOOLEAN := TRUE;