APPS.PA_ALLOC_RUN dependencies on PA_RESOURCE_LIST_MEMBERS

Line 4538: from pa_resource_list_members pbr,

4534: Select par.resource_list_member_id ,
4535: par.exclude_flag ,
4536: nvl(pbr.parent_member_id,0) parent_member_id,
4537: par.resource_percentage
4538: from pa_resource_list_members pbr,
4539: /** pa_budget_resources_v pbr, ** bug 2661889 */
4540: pa_alloc_resources par
4541: where par.rule_id = p_rule_id
4542: and par.member_type = p_type

Line 4570: * from pa_resource_list_members

4566: * Modified Cursor query for performance improvement.
4567: * --2564418. Added the second condition in the where clause below
4568: * cursor C_RL_RLM is
4569: * Select resource_list_member_id
4570: * from pa_resource_list_members
4571: * -- pa_budget_resources_v -- bug 2661889
4572: * where resource_list_id = p_resource_list_id
4573: * -- 2564418 changes start
4574: * AND resource_list_member_id NOT IN

Line 4584: From pa_resource_list_members prlm

4580: ****************** End of comment *****************************/
4581: Cursor C_RL_RLM_ALL is /* Cursor Created for performnace : Derived from C_RL_RLM and removed the exists call.
4582: This cursor will be used When no include and no exclude is defined. */
4583: Select prlm.resource_list_member_id
4584: From pa_resource_list_members prlm
4585: Where prlm.resource_list_id = p_resource_list_id
4586: And display_flag = 'Y' /* FP.M : Allocation Impact Bug # 3512552 */
4587: And enabled_flag = 'Y' /* FP.M : Allocation Impact Bug # 3512552 */
4588: And nvl(prlm.migration_code , 'M') = 'M';

Line 4617: from pa_resource_list_members prlm

4613: and prbs.resource_type_id <> -1 ; /* To remove first record of Version Info*/
4614: /* In this case, data can be there for intermediate nodes also. So to insert all the records */
4615: Cursor C_RL_RLM is
4616: Select prlm.resource_list_member_id
4617: from pa_resource_list_members prlm
4618: where prlm.resource_list_id = p_resource_list_id
4619: And display_flag = 'Y' /* FP.M : Allocation Impact Bug # 3512552 */
4620: And enabled_flag = 'Y' /* FP.M : Allocation Impact Bug # 3512552 */
4621: And nvl(prlm.migration_code , 'M') = 'M'

Line 4671: from pa_resource_list_members

4667: /****************** Bug 3149853 Ends ***************************/
4668: -- Cursor to all defined resource list members of a resource group
4669: Cursor C_RG_RLM is
4670: Select resource_list_member_id
4671: from pa_resource_list_members
4672: /** pa_budget_resources_v ** bug 2661889 */
4673: where nvl(parent_member_id,0) = v_rlm_id
4674: and resource_list_id = p_resource_list_id
4675: and display_flag = 'Y' /* FP.M : Allocation Impact Bug # 3512552 */

Line 4767: from pa_resource_list_members

4763: IS
4764: v_rlm_exists VARCHAR2(1) ;
4765: cursor c_child_rlm is
4766: select 'Y'
4767: from pa_resource_list_members
4768: /** pa_budget_resources_v ** bug 2661889 */
4769: where nvl(parent_member_id,0) = p_rlm_id
4770: and display_flag = 'Y' /* FP.M : Allocation Impact Bug # 3512552 */
4771: and enabled_flag = 'Y' /* FP.M : Allocation Impact Bug # 3512552 */

Line 4894: From pa_resource_list_members

4890: Declare
4891: Cursor C_Exc_Chd_Rlm (V_parent_rlm in Number)
4892: Is
4893: Select resource_list_member_id
4894: From pa_resource_list_members
4895: Where Resource_List_Id = p_resource_list_Id
4896: And Parent_member_Id = v_parent_rlm
4897: And display_flag = 'Y' /* FP.M : Allocation Impact Bug # 3512552 */
4898: And enabled_flag = 'Y' /* FP.M : Allocation Impact Bug # 3512552 */