APPS.PON_ADD_UTIL_PKG dependencies on HZ_PARTY_SITE_USES

Line 60: l_bill_to hz_party_site_uses.SITE_USE_TYPE%TYPE;

56: )
57:
58: IS
59: l_exception_msg varchar2(100);
60: l_bill_to hz_party_site_uses.SITE_USE_TYPE%TYPE;
61: l_ship_to hz_party_site_uses.SITE_USE_TYPE%TYPE;
62: l_mail_to hz_party_site_uses.SITE_USE_TYPE%TYPE;
63:
64: BEGIN

Line 61: l_ship_to hz_party_site_uses.SITE_USE_TYPE%TYPE;

57:
58: IS
59: l_exception_msg varchar2(100);
60: l_bill_to hz_party_site_uses.SITE_USE_TYPE%TYPE;
61: l_ship_to hz_party_site_uses.SITE_USE_TYPE%TYPE;
62: l_mail_to hz_party_site_uses.SITE_USE_TYPE%TYPE;
63:
64: BEGIN
65:

Line 62: l_mail_to hz_party_site_uses.SITE_USE_TYPE%TYPE;

58: IS
59: l_exception_msg varchar2(100);
60: l_bill_to hz_party_site_uses.SITE_USE_TYPE%TYPE;
61: l_ship_to hz_party_site_uses.SITE_USE_TYPE%TYPE;
62: l_mail_to hz_party_site_uses.SITE_USE_TYPE%TYPE;
63:
64: BEGIN
65:
66: l_bill_to := 'BILL_TO';

Line 90: , hz_party_site_uses hpsu_ship_to

86: , DECODE (hpsu_mail_to.site_use_type, l_mail_to,'Y','N')
87:
88: FROM hz_locations hl
89: , hz_party_sites hps
90: , hz_party_site_uses hpsu_ship_to
91: , hz_party_site_uses hpsu_bill_to
92: , hz_party_site_uses hpsu_mail_to
93:
94: WHERE hl.location_id = p_location_id

Line 91: , hz_party_site_uses hpsu_bill_to

87:
88: FROM hz_locations hl
89: , hz_party_sites hps
90: , hz_party_site_uses hpsu_ship_to
91: , hz_party_site_uses hpsu_bill_to
92: , hz_party_site_uses hpsu_mail_to
93:
94: WHERE hl.location_id = p_location_id
95: AND hps.location_id = hl.location_id

Line 92: , hz_party_site_uses hpsu_mail_to

88: FROM hz_locations hl
89: , hz_party_sites hps
90: , hz_party_site_uses hpsu_ship_to
91: , hz_party_site_uses hpsu_bill_to
92: , hz_party_site_uses hpsu_mail_to
93:
94: WHERE hl.location_id = p_location_id
95: AND hps.location_id = hl.location_id
96: AND hpsu_ship_to.party_site_id(+) = hps.party_site_id