DBA Data[Home] [Help]

APPS.GMS_BUDG_CONT_SETUP dependencies on PA_RESOURCE_LIST_MEMBERS

Line 149: FROM PA_RESOURCE_LIST_MEMBERS br

145: 0,x_funds_control_code_res,
146: x_funds_control_code_resgrp),
147: x_funds_control_code_res
148: ) funds_control_level
149: FROM PA_RESOURCE_LIST_MEMBERS br
150: WHERE br.ENABLED_FLAG = 'Y'
151: AND br.RESOURCE_LIST_ID = x_resource_list_id
152: AND DECODE(br.RESOURCE_TYPE_CODE, 'UNCLASSIFIED', 'Y', DISPLAY_FLAG) = 'Y'
153: and nvl(br.migration_code, 'M') = 'M'

Line 169: FROM PA_RESOURCE_LIST_MEMBERS br

165: 0,x_funds_control_code_res,
166: x_funds_control_code_resgrp),
167: x_funds_control_code_res
168: ) funds_control_level
169: FROM PA_RESOURCE_LIST_MEMBERS br
170: WHERE br.ENABLED_FLAG = 'Y'
171: AND br.RESOURCE_LIST_ID = x_resource_list_id
172: AND DECODE(br.RESOURCE_TYPE_CODE, 'UNCLASSIFIED', 'Y', DISPLAY_FLAG) = 'Y'
173: and nvl(br.migration_code, 'M') = 'M';