APPS.PN_VAR_RENT_CALC_PKG dependencies on PN_PROPERTIES_ALL

Line 6407: l_prop_code pn_properties_all.property_code%TYPE := p_property_code; /* 9765197 */

6403: p_period_date IN VARCHAR2,
6404: p_org_id IN NUMBER )
6405: IS
6406:
6407: l_prop_code pn_properties_all.property_code%TYPE := p_property_code; /* 9765197 */
6408:
6409: CURSOR csr_get_vrent_wprop IS
6410: SELECT pvr.var_rent_id,
6411: pvr.invoice_on,

Line 6429: FROM pn_properties_all

6425: IN
6426: (SELECT location_id
6427: FROM pn_locations_all
6428: WHERE property_id IN(SELECT property_id
6429: FROM pn_properties_all
6430: WHERE property_code=NVL(l_prop_code,property_code))
6431: --OR property_name=NVL(p_property_name,property_name)) /* 9765197 */
6432: )
6433: CONNECT BY PRIOR location_id=parent_location_id)

Line 6549: FROM PN_PROPERTIES_ALL

6545:
6546: IF p_property_name is not null and p_property_code is null THEN /* 9765197 */
6547: SELECT PROPERTY_CODE
6548: into l_prop_code
6549: FROM PN_PROPERTIES_ALL
6550: where property_name = p_property_name;
6551: END IF;
6552:
6553: