APPS.HZ_MGD_MASS_UPDATE_MEDIATOR dependencies on HZ_CUST_SITE_USES

Line 54: l_site_name hz_cust_site_uses.location%TYPE;

50: )
51: IS
52: l_cust_name hz_parties.party_name%TYPE;
53: l_cust_num hz_parties.party_number%TYPE;
54: l_site_name hz_cust_site_uses.location%TYPE;
55:
56: BEGIN
57:
58: HZ_MGD_MASS_UPDATE_REP_GEN.log

Line 118: hz_cust_site_uses

114: location
115: INTO
116: x_site_name
117: FROM
118: hz_cust_site_uses
119: WHERE site_use_id=p_entity_id;
120:
121: SELECT
122: SUBSTRB(hp.party_name,1,30)