APPS.PA_ACCUM_API dependencies on PA_RESOURCE_LIST_MEMBERS

Line 458: FROM PA_RESOURCE_LIST_MEMBERS PRLM

454: AND PRAD.RESOURCE_LIST_MEMBER_ID IN
455: -- Modified for bug 4390421
456: ( -- Fetch both 2nd level and group level resource list member
457: SELECT PRLM.RESOURCE_LIST_MEMBER_ID
458: FROM PA_RESOURCE_LIST_MEMBERS PRLM
459: WHERE (prlm.resource_list_member_id = X_RESOURCE_LIST_MEMBER_ID
460: or
461: PRLM.PARENT_MEMBER_ID = X_RESOURCE_LIST_MEMBER_ID )
462: /* Commented for bug 4390421

Line 467: PA_RESOURCE_LIST_MEMBERS PRLM

463: (
464: SELECT -- 2nd level resource list members
465: PRLM.RESOURCE_LIST_MEMBER_ID
466: FROM
467: PA_RESOURCE_LIST_MEMBERS PRLM
468: WHERE
469: PRLM.PARENT_MEMBER_ID = X_RESOURCE_LIST_MEMBER_ID
470: UNION
471: SELECT -- Group level Resource list member

Line 543: FROM PA_RESOURCE_LIST_MEMBERS PRLM

539: AND PRAD.RESOURCE_LIST_MEMBER_ID IN
540: -- Modified for bug 4390421
541: ( -- Fetch both 2nd level and group level resource list member
542: SELECT PRLM.RESOURCE_LIST_MEMBER_ID
543: FROM PA_RESOURCE_LIST_MEMBERS PRLM
544: WHERE (prlm.resource_list_member_id = X_RESOURCE_LIST_MEMBER_ID
545: or
546: PRLM.PARENT_MEMBER_ID = X_RESOURCE_LIST_MEMBER_ID )
547: /*

Line 552: PA_RESOURCE_LIST_MEMBERS PRLM

548: (
549: SELECT -- 2nd level resource list members
550: PRLM.RESOURCE_LIST_MEMBER_ID
551: FROM
552: PA_RESOURCE_LIST_MEMBERS PRLM
553: WHERE
554: PRLM.PARENT_MEMBER_ID = X_RESOURCE_LIST_MEMBER_ID
555: UNION
556: SELECT -- Group level Resource list member

Line 941: pa_resource_list_members rlm

937: (
938: SELECT -- 2nd level resource list members
939: rlm.resource_list_member_id
940: FROM
941: pa_resource_list_members rlm
942: WHERE
943: rlm.parent_member_id = x_resource_list_member_id
944: UNION
945: SELECT -- Group level Resource list member

Line 991: pa_resource_list_members rlm

987: (
988: SELECT -- 2nd level resource list members
989: rlm.resource_list_member_id
990: FROM
991: pa_resource_list_members rlm
992: WHERE
993: rlm.parent_member_id = x_resource_list_member_id
994: UNION
995: SELECT -- Group level Resource list member