APPS.PQP_SS_VEHICLE_TRANSACTIONS dependencies on PQP_VEH_REPOS_INFO_TYPES

Line 50: FROM pqp_veh_repos_info_types ait, fnd_descr_flex_contexts_vl flv

46: l_count number:=0;
47: l_exists VARCHAR2(1);
48: CURSOR c_get_info IS
49: SELECT COUNT(1)
50: FROM pqp_veh_repos_info_types ait, fnd_descr_flex_contexts_vl flv
51: WHERE ait.information_type = flv.descriptive_flex_context_code
52: AND flv.descriptive_flexfield_name IN ( 'Vehicle Repos Extra Info DDF'
53: ,'Vehicle Alloc Extra Info DDF')
54: AND flv.enabled_flag = 'Y'

Line 57: pqp_veh_repos_info_types ait

53: ,'Vehicle Alloc Extra Info DDF')
54: AND flv.enabled_flag = 'Y'
55: AND exists ( SELECT NULL
56: FROM per_info_type_security its,
57: pqp_veh_repos_info_types ait
58: WHERE its.info_type_table_name IN ( 'PQP_VEH_REPOS_INFO_TYPES'
59: ,'PQP_VEH_ALLOC_INFO_TYPES')
60: AND its.information_type = ait.information_type
61: AND responsibility_id = l_responsibility_id );

Line 58: WHERE its.info_type_table_name IN ( 'PQP_VEH_REPOS_INFO_TYPES'

54: AND flv.enabled_flag = 'Y'
55: AND exists ( SELECT NULL
56: FROM per_info_type_security its,
57: pqp_veh_repos_info_types ait
58: WHERE its.info_type_table_name IN ( 'PQP_VEH_REPOS_INFO_TYPES'
59: ,'PQP_VEH_ALLOC_INFO_TYPES')
60: AND its.information_type = ait.information_type
61: AND responsibility_id = l_responsibility_id );
62: