APPS.PN_INDEX_AMOUNT_PKG dependencies on PN_LOCATIONS

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

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

Line 6773: (SELECT location_id FROM pn_locations

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