APPS.IGS_FI_PRC_1098T_DATA dependencies on HZ_PARTIES

Line 20: p_v_con_party_name OUT NOCOPY hz_parties.party_name%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,
18: p_v_phone_number OUT NOCOPY hz_contact_points.phone_number%type,
19: p_v_phone_extension OUT NOCOPY hz_contact_points.phone_extension%type,
20: p_v_con_party_name OUT NOCOPY hz_parties.party_name%type,
21: p_v_party_name OUT NOCOPY hz_parties.party_name%type,
22: p_v_email_address OUT NOCOPY hz_parties.email_address%type,
23: p_v_country OUT NOCOPY hz_locations.country%type,
24: p_v_address1 OUT NOCOPY hz_locations.address1%type,

Line 21: p_v_party_name OUT NOCOPY hz_parties.party_name%type,

17: p_v_phone_area_code OUT NOCOPY hz_contact_points.phone_area_code%type,
18: p_v_phone_number OUT NOCOPY hz_contact_points.phone_number%type,
19: p_v_phone_extension OUT NOCOPY hz_contact_points.phone_extension%type,
20: p_v_con_party_name OUT NOCOPY hz_parties.party_name%type,
21: p_v_party_name OUT NOCOPY hz_parties.party_name%type,
22: p_v_email_address OUT NOCOPY hz_parties.email_address%type,
23: p_v_country OUT NOCOPY hz_locations.country%type,
24: p_v_address1 OUT NOCOPY hz_locations.address1%type,
25: p_v_address2 OUT NOCOPY hz_locations.address2%type,

Line 22: p_v_email_address OUT NOCOPY hz_parties.email_address%type,

18: p_v_phone_number OUT NOCOPY hz_contact_points.phone_number%type,
19: p_v_phone_extension OUT NOCOPY hz_contact_points.phone_extension%type,
20: p_v_con_party_name OUT NOCOPY hz_parties.party_name%type,
21: p_v_party_name OUT NOCOPY hz_parties.party_name%type,
22: p_v_email_address OUT NOCOPY hz_parties.email_address%type,
23: p_v_country OUT NOCOPY hz_locations.country%type,
24: p_v_address1 OUT NOCOPY hz_locations.address1%type,
25: p_v_address2 OUT NOCOPY hz_locations.address2%type,
26: p_v_address3 OUT NOCOPY hz_locations.address3%type,

Line 48: CURSOR c_contact_name (c_n_party_id in hz_parties.party_id%TYPE ) IS

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
49: SELECT party_name FROM
50: hz_parties
51: WHERE party_id = c_n_party_id;
52:

Line 50: hz_parties

46:
47:
48: CURSOR c_contact_name (c_n_party_id in hz_parties.party_id%TYPE ) IS
49: SELECT party_name FROM
50: hz_parties
51: WHERE party_id = c_n_party_id;
52:
53: CURSOR c_location_details (c_n_LOCATION_ID in HZ_LOCATIONS.LOCATION_ID%TYPE ) IS
54: SELECT country,address1,address2,address3,address4,city,

Line 61: FROM hz_parties hp_name, hz_relationships hr, hz_parties hp_email

57: WHERE location_id = c_n_LOCATION_ID;
58:
59: CURSOR c_name_mailid IS
60: SELECT hp_name.party_name, hp_email.email_address
61: FROM hz_parties hp_name, hz_relationships hr, hz_parties hp_email
62: WHERE hr.relationship_id = p_n_relationship_id
63: AND hr.directional_flag = 'B'
64: AND hp_name.party_id = hr.object_id
65: AND hr.party_id = hp_email.party_id;