APPS.PA_ALLOC_RUN dependencies on PA_RESOURCE_LIST_MEMBERS

Line 4515: from pa_resource_list_members pbr,

4511: Select par.resource_list_member_id ,
4512: par.exclude_flag ,
4513: nvl(pbr.parent_member_id,0) parent_member_id,
4514: par.resource_percentage
4515: from pa_resource_list_members pbr,
4516: /** pa_budget_resources_v pbr, ** bug 2661889 */
4517: pa_alloc_resources par
4518: where par.rule_id = p_rule_id
4519: and par.member_type = p_type

Line 4547: * from pa_resource_list_members

4543: * Modified Cursor query for performance improvement.
4544: * --2564418. Added the second condition in the where clause below
4545: * cursor C_RL_RLM is
4546: * Select resource_list_member_id
4547: * from pa_resource_list_members
4548: * -- pa_budget_resources_v -- bug 2661889
4549: * where resource_list_id = p_resource_list_id
4550: * -- 2564418 changes start
4551: * AND resource_list_member_id NOT IN

Line 4561: From pa_resource_list_members prlm

4557: ****************** End of comment *****************************/
4558: Cursor C_RL_RLM_ALL is /* Cursor Created for performnace : Derived from C_RL_RLM and removed the exists call.
4559: This cursor will be used When no include and no exclude is defined. */
4560: Select prlm.resource_list_member_id
4561: From pa_resource_list_members prlm
4562: Where prlm.resource_list_id = p_resource_list_id
4563: And display_flag = 'Y' /* FP.M : Allocation Impact Bug # 3512552 */
4564: And enabled_flag = 'Y' /* FP.M : Allocation Impact Bug # 3512552 */
4565: And nvl(prlm.migration_code , 'M') = 'M';

Line 4594: from pa_resource_list_members prlm

4590: and prbs.resource_type_id <> -1 ; /* To remove first record of Version Info*/
4591: /* In this case, data can be there for intermediate nodes also. So to insert all the records */
4592: Cursor C_RL_RLM is
4593: Select prlm.resource_list_member_id
4594: from pa_resource_list_members prlm
4595: where prlm.resource_list_id = p_resource_list_id
4596: And display_flag = 'Y' /* FP.M : Allocation Impact Bug # 3512552 */
4597: And enabled_flag = 'Y' /* FP.M : Allocation Impact Bug # 3512552 */
4598: And nvl(prlm.migration_code , 'M') = 'M'

Line 4648: from pa_resource_list_members

4644: /****************** Bug 3149853 Ends ***************************/
4645: -- Cursor to all defined resource list members of a resource group
4646: Cursor C_RG_RLM is
4647: Select resource_list_member_id
4648: from pa_resource_list_members
4649: /** pa_budget_resources_v ** bug 2661889 */
4650: where nvl(parent_member_id,0) = v_rlm_id
4651: and resource_list_id = p_resource_list_id
4652: and display_flag = 'Y' /* FP.M : Allocation Impact Bug # 3512552 */

Line 4744: from pa_resource_list_members

4740: IS
4741: v_rlm_exists VARCHAR2(1) ;
4742: cursor c_child_rlm is
4743: select 'Y'
4744: from pa_resource_list_members
4745: /** pa_budget_resources_v ** bug 2661889 */
4746: where nvl(parent_member_id,0) = p_rlm_id
4747: and display_flag = 'Y' /* FP.M : Allocation Impact Bug # 3512552 */
4748: and enabled_flag = 'Y' /* FP.M : Allocation Impact Bug # 3512552 */

Line 4871: From pa_resource_list_members

4867: Declare
4868: Cursor C_Exc_Chd_Rlm (V_parent_rlm in Number)
4869: Is
4870: Select resource_list_member_id
4871: From pa_resource_list_members
4872: Where Resource_List_Id = p_resource_list_Id
4873: And Parent_member_Id = v_parent_rlm
4874: And display_flag = 'Y' /* FP.M : Allocation Impact Bug # 3512552 */
4875: And enabled_flag = 'Y' /* FP.M : Allocation Impact Bug # 3512552 */