APPS.PN_TENANCIES_PKG dependencies on PN_REC_EXPCL_DTLLN_ALL

Line 1317: pn_rec_expcl_dtlln_all dtl

1313: WHERE mst.area_class_dtl_id = dtl.area_class_dtl_id
1314: AND dtl.cust_space_assign_id = spc.cust_space_assign_id) OR
1315: EXISTS (SELECT NULL
1316: FROM pn_rec_expcl_dtl_all mst,
1317: pn_rec_expcl_dtlln_all dtl
1318: WHERE mst.expense_class_dtl_id = dtl.expense_class_dtl_id
1319: AND dtl.cust_space_assign_id = spc.cust_space_assign_id))
1320: );
1321:

Line 1338: pn_rec_expcl_dtlln_all dtl

1334: AND mst.status = 'LOCKED'
1335: AND dtl.cust_space_assign_id = spc.cust_space_assign_id) OR
1336: EXISTS (SELECT NULL
1337: FROM pn_rec_expcl_dtl_all mst,
1338: pn_rec_expcl_dtlln_all dtl
1339: WHERE mst.expense_class_dtl_id = dtl.expense_class_dtl_id
1340: AND mst.status = 'LOCKED'
1341: AND dtl.cust_space_assign_id = spc.cust_space_assign_id))
1342: );

Line 2197: DELETE FROM pn_rec_expcl_dtlln_all

2193: l_auto_space_dist := NVL(pn_mo_cache_utils.get_profile_value('PN_AUTOMATIC_SPACE_DISTRIBUTION',l_org_id),'N');
2194: pnp_debug_pkg.debug('PN_TENANCIES_PKG.DELETE_AUTO_SPACE_ASSIGN (+) Auto_Space_Dist: '
2195: ||l_auto_space_dist||', TenancyId: '||p_tenancy_id);
2196:
2197: DELETE FROM pn_rec_expcl_dtlln_all
2198: WHERE cust_space_assign_id IN (SELECT cust_space_assign_id
2199: FROM pn_space_assign_cust_all
2200: WHERE tenancy_id = p_tenancy_id);
2201: l_count := SQL%ROWCOUNT;