APPS.PN_REC_EXP_EXTR_FROM_GL_PKG dependencies on PN_LOC_ACC_MAP_ALL

Line 1859: From PN_LOC_ACC_MAP_ALL map

1855: /* cursors for mapping */
1856:
1857: CURSOR mapping IS
1858: Select map.*
1859: From PN_LOC_ACC_MAP_ALL map
1860: Where map.LOC_ACC_MAP_HDR_ID = p_loc_acc_map_hdr_id
1861: And map.RECOVERABLE_FLAG = 'Y'
1862: And map.effective_from_date <= l_period_end_enddt
1863: And map.effective_to_date >= l_period_start_stdt;

Line 1867: From PN_LOC_ACC_MAP_ALL map

1863: And map.effective_to_date >= l_period_start_stdt;
1864:
1865: CURSOR mapping_loc IS
1866: Select map.*
1867: From PN_LOC_ACC_MAP_ALL map
1868: Where map.LOC_ACC_MAP_HDR_ID = p_loc_acc_map_hdr_id
1869: And map.LOCATION_ID = p_location_id
1870: And map.RECOVERABLE_FLAG = 'Y'
1871: And map.effective_from_date <= l_period_end_enddt

Line 1876: From PN_LOC_ACC_MAP_ALL map

1872: And map.effective_to_date >= l_period_start_stdt;
1873:
1874: CURSOR mapping_prop IS
1875: Select map.*
1876: From PN_LOC_ACC_MAP_ALL map
1877: Where map.LOC_ACC_MAP_HDR_ID = p_loc_acc_map_hdr_id
1878: And map.PROPERTY_ID = p_property_id
1879: And map.RECOVERABLE_FLAG = 'Y'
1880: And map.effective_from_date <= l_period_end_enddt

Line 1885: From PN_LOC_ACC_MAP_ALL map

1881: And map.effective_to_date >= l_period_start_stdt;
1882:
1883: CURSOR mapping_loc_prop IS
1884: Select map.*
1885: From PN_LOC_ACC_MAP_ALL map
1886: Where map.LOC_ACC_MAP_HDR_ID = p_loc_acc_map_hdr_id
1887: And map.PROPERTY_ID = p_property_id
1888: And map.LOCATION_ID = p_location_id
1889: And map.RECOVERABLE_FLAG = 'Y'