APPS.IGS_CO_GEN_003 dependencies on HZ_PARTIES

Line 39: FROM hz_parties per,

35: DECODE (per.person_last_name, NULL, NULL, ' ' ||
36: per.person_last_name) ||
37: DECODE (per.person_name_suffix, NULL, NULL, ' ' ||
38: per.person_name_suffix) person_name
39: FROM hz_parties per,
40: fnd_lookup_values lkup
41: WHERE per.party_id = cp_person_id
42: AND per.person_pre_name_adjunct = lkup.lookup_code (+)
43: AND lkup.lookup_type (+) = cp_lookup_type

Line 49: -- Cursor for selection of the person address for Correspondence from HZ_PARTIES.

45: AND lkup.view_application_id(+) = cp_view_application_id
46: AND lkup.security_group_id(+) = cp_security_group_id;
47:
48: --
49: -- Cursor for selection of the person address for Correspondence from HZ_PARTIES.
50: --
51: CURSOR cur_person_address (
52: cp_person_id IN NUMBER
53: ) IS

Line 63: FROM hz_parties addr,

59: DECODE (addr.state, NULL, NULL, l_line_break || addr.state) ||
60: DECODE (addr.postal_code, NULL, NULL, ' ' || addr.postal_code) ||
61: DECODE (tr.territory_short_name, NULL, NULL, l_line_break ||
62: tr.territory_short_name) person_address
63: FROM hz_parties addr,
64: fnd_territories_vl tr
65: WHERE addr.party_id = cp_person_id
66: AND addr.country = tr.territory_code(+);
67: