APPS.PN_CAD_IMPORT dependencies on PN_SPACE_ASSIGN_EMP_ALL

Line 1693: tlempinfo pn_space_assign_emp_all%ROWTYPE;

1689: FROM pn_emp_space_assign_itf spc
1690: WHERE spc.batch_name = p_batch_name
1691: AND spc.transferred_to_pn is null;
1692:
1693: tlempinfo pn_space_assign_emp_all%ROWTYPE;
1694:
1695: l_error_message VarChar2(512);
1696:
1697: l_assignable_area Number;

Line 1780: FROM pn_space_assign_emp_all

1776:
1777: IF space.emp_space_assign_id IS NOT NULL THEN
1778: SELECT *
1779: INTO tlempinfo
1780: FROM pn_space_assign_emp_all
1781: WHERE EMP_SPACE_ASSIGN_ID = space.EMP_SPACE_ASSIGN_ID;
1782: END IF;
1783:
1784: IF tlempinfo.emp_space_assign_id IS NULL THEN