APPS.PN_INDEX_AMOUNT_PKG dependencies on PN_LOCATIONS

Line 6718: -- 25-NOV-05 pikhar o Replaced pn_locations_all with pn_locations

6714: -- 09-MAR-05 ftanudja o Used profile option 'PN_RECALC_INDEX_RENT'
6715: -- for recalculate logic. #4212326.
6716: -- 15-SEP-05 pikhar o replaced fnd_profile.value(PN_RECALC_INDEX_RENT)
6717: -- with pn_mo_cache_utils.get_profile_value
6718: -- 25-NOV-05 pikhar o Replaced pn_locations_all with pn_locations
6719: -- 15-DEC-05 pikhar o replaced get_profile_value(PN_RECALC_INDEX_RENT) with
6720: -- get_profile_value('RECALC_IR_ON_ACC_CHG_FLAG'
6721: -------------------------------------------------------------------------------
6722:

Line 6771: (SELECT location_id FROM pn_locations

6767: pilp.assessment_date))
6768: )
6769: AND (pl.lease_class_code = nvl(p_lease_class,pl.lease_class_code))
6770: AND (p_location_code is null OR pil.location_id IN
6771: (SELECT location_id FROM pn_locations
6772: START WITH location_code = p_location_code
6773: CONNECT BY PRIOR location_id = parent_location_id)
6774: )
6775: AND (pil.abstracted_by = p_user_responsible OR