APPS.JTF_TASK_UTL dependencies on JTF_PERZ_DATA

Line 3146: FROM jtf_perz_data

3142:
3143: l_profile_name := TO_CHAR(l_resource_id)||g_perz_suffix;
3144:
3145: SELECT perz_data_id into l_category_id
3146: FROM jtf_perz_data
3147: WHERE profile_id = (SELECT profile_id
3148: FROM jtf_perz_profile
3149: WHERE profile_name = l_profile_name)
3150: AND perz_data_id = p_category_id;

Line 3616: from jtf_perz_data

3612: l_msg_data := substrb(fnd_msg_pub.get( 1 , 'F' ),1,240); -- Fixed for bug 2540722
3613: else
3614: select perz_data_desc
3615: into l_msg_data
3616: from jtf_perz_data
3617: where perz_data_id = p_category_id ;
3618: end if;
3619:
3620: return l_msg_data;

Line 3664: where category in ( select perz_data_id from jtf_perz_data where perz_data_name = p_category_name ) ;

3660: begin
3661:
3662: update jtf_cal_addresses
3663: set category = null
3664: where category in ( select perz_data_id from jtf_perz_data where perz_data_name = p_category_name ) ;
3665:
3666:
3667: update jtf_task_all_assignments
3668: set category_id = null

Line 3669: where category_id in ( select perz_data_id from jtf_perz_data where perz_data_name = p_category_name ) ;

3665:
3666:
3667: update jtf_task_all_assignments
3668: set category_id = null
3669: where category_id in ( select perz_data_id from jtf_perz_data where perz_data_name = p_category_name ) ;
3670:
3671:
3672: delete from jtf_perz_data where perz_data_name = p_category_name ;
3673:

Line 3672: delete from jtf_perz_data where perz_data_name = p_category_name ;

3668: set category_id = null
3669: where category_id in ( select perz_data_id from jtf_perz_data where perz_data_name = p_category_name ) ;
3670:
3671:
3672: delete from jtf_perz_data where perz_data_name = p_category_name ;
3673:
3674: commit ;
3675: exception
3676: when others then