APPS.IGS_FI_PRC_1098T_DATA dependencies on HZ_PARTY_SITES

Line 13: PROCEDURE contactdetails ( p_n_party_site_id IN hz_party_sites.party_site_id%type,

9: Known limitations,enhancements,remarks:
10: Change History
11: Who When What
12: *************************************************************************/
13: PROCEDURE contactdetails ( p_n_party_site_id IN hz_party_sites.party_site_id%type,
14: p_n_relationship_id IN hz_relationships.relationship_id%type,
15: p_n_contact_point_id IN hz_contact_points.contact_point_id%type,
16: p_v_phone_country_code OUT NOCOPY hz_contact_points.phone_country_code%type,
17: p_v_phone_area_code OUT NOCOPY hz_contact_points.phone_area_code%type,

Line 42: CURSOR c_party_loc_id (c_n_party_site_id in hz_party_sites.party_site_id%TYPE ) IS

38: Known limitations,enhancements,remarks:
39: Change History
40: Who When What
41: *************************************************************************/
42: CURSOR c_party_loc_id (c_n_party_site_id in hz_party_sites.party_site_id%TYPE ) IS
43: SELECT party_id ,location_id
44: FROM hz_party_sites WHERE PARTY_SITE_ID =c_n_PARTY_SITE_ID;
45: rec_party_loc_id c_party_loc_id%rowtype;
46:

Line 44: FROM hz_party_sites WHERE PARTY_SITE_ID =c_n_PARTY_SITE_ID;

40: Who When What
41: *************************************************************************/
42: CURSOR c_party_loc_id (c_n_party_site_id in hz_party_sites.party_site_id%TYPE ) IS
43: SELECT party_id ,location_id
44: FROM hz_party_sites WHERE PARTY_SITE_ID =c_n_PARTY_SITE_ID;
45: rec_party_loc_id c_party_loc_id%rowtype;
46:
47:
48: CURSOR c_contact_name (c_n_party_id in hz_parties.party_id%TYPE ) IS