DBA Data[Home] [Help]

APPS.PA_PLAN_RES_DEFAULTS_PUB dependencies on PA_RES_TYPES_B

Line 72: pa_res_types_b types

68: BEGIN
69: select 'Y'
70: into l_master_used
71: from pa_res_formats_b format,
72: pa_res_types_b types
73: where types.res_type_code = 'INVENTORY_ITEM'
74: and types.res_type_id = format.res_type_id
75: and exists (select 'Y'
76: from PA_RESOURCE_LIST_MEMBERS rlm

Line 129: pa_res_types_b types

125: BEGIN
126: select 'Y'
127: into l_category_used
128: from pa_res_formats_b format,
129: pa_res_types_b types
130: where types.res_type_code = 'ITEM_CATEGORY'
131: and types.res_type_id = format.res_type_id
132: and exists (select 'Y'
133: from PA_RESOURCE_LIST_MEMBERS rlm