APPS.PN_CC_SYNC_PKG dependencies on PN_SPACE_ASSIGN_EMP_ALL

Line 56: asg_rec pn_space_assign_emp_ALL%ROWTYPE;

52: p_emp_cost_center IN pn_space_assign_emp.cost_center_code%TYPE
53: ) IS
54:
55:
56: asg_rec pn_space_assign_emp_ALL%ROWTYPE;
57: l_query VARCHAR2(2000);
58: l_where_clause VARCHAR2(2000);
59: l_where_clause_loc VARCHAR2(2000) := NULL;
60: l_count_total NUMBER := 0;