APPS.HXC_PROJ_MANAGER_APPROVAL_PKG dependencies on HXC_TIME_CATEGORIES

Line 45: and TIME_CATEGORY_ID IN ( SELECT TIME_CATEGORY_ID FROM HXC_TIME_CATEGORIES

41: is
42: select time_category_comp_id, object_version_number, time_category_id
43: from hxc_time_category_comps
44: where value_id = to_char(l_project_id)
45: and TIME_CATEGORY_ID IN ( SELECT TIME_CATEGORY_ID FROM HXC_TIME_CATEGORIES
46: WHERE TIME_CATEGORY_NAME LIKE 'PROJECT MANAGER :: % SYSTEM GENERATED DO NOT MODIFY' );
47:
48:
49:

Line 50: cursor csr_get_time_category_name(l_time_category_name hxc_time_categories.TIME_CATEGORY_NAME%TYPE)

46: WHERE TIME_CATEGORY_NAME LIKE 'PROJECT MANAGER :: % SYSTEM GENERATED DO NOT MODIFY' );
47:
48:
49:
50: cursor csr_get_time_category_name(l_time_category_name hxc_time_categories.TIME_CATEGORY_NAME%TYPE)
51: is
52: select time_category_id from hxc_time_categories where time_category_name = l_time_category_name;
53:
54:

Line 52: select time_category_id from hxc_time_categories where time_category_name = l_time_category_name;

48:
49:
50: cursor csr_get_time_category_name(l_time_category_name hxc_time_categories.TIME_CATEGORY_NAME%TYPE)
51: is
52: select time_category_id from hxc_time_categories where time_category_name = l_time_category_name;
53:
54:
55: cursor csr_get_approval_mechanism( l_approval_style_id in number, l_time_category_id in number)
56: is

Line 97: l_time_category_name hxc_time_categories.TIME_CATEGORY_NAME%TYPE;

93: l_mechanism_id NUMBER;
94: l_def_approval_mech VARCHAR2(100);
95: l_def_approval_mech_id NUMBER;
96: l_dyn_sql VARCHAR2(2000);
97: l_time_category_name hxc_time_categories.TIME_CATEGORY_NAME%TYPE;
98:
99:
100: l_proc varchar2(100);
101: begin