APPS.JTA_SYNC_TASK_CATEGORY dependencies on JTF_PERZ_DATA

Line 55: FROM JTF_PERZ_DATA

51: ) RETURN NUMBER
52: IS
53: CURSOR c_category_id (b_category_name VARCHAR2) IS -- Fix bug 2418798
54: SELECT perz_data_id
55: FROM JTF_PERZ_DATA
56: WHERE perz_data_desc = b_category_name
57: AND profile_id = p_profile_id;
58:
59: l_category_id NUMBER;

Line 75: FROM JTF_PERZ_DATA

71: )
72: IS
73: CURSOR c_categories (b_profile_id NUMBER) IS
74: SELECT perz_data_id
75: FROM JTF_PERZ_DATA
76: WHERE profile_id = b_profile_id;
77:
78: l_category_id NUMBER;
79: l_category_name VARCHAR2(240) := truncate_category_name(p_category_name); --Fix bug 2418798, Fix bug 2540722

Line 115: jtf_perz_data_pub.create_perz_data

111: SELECT jtf_task_category_s.nextval
112: INTO category_seq
113: FROM sys.dual;
114:
115: jtf_perz_data_pub.create_perz_data
116: (p_api_version_number => 1.0,
117: p_application_id => 690,
118: p_profile_id => l_profile_id,
119: p_profile_name => NULL,