eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_RES_ACCUMS dependencies on PA_RESOURCE_LIST_MEMBERS

Line 804: pa_resource_list_members rlm,

800: rt.resource_type_code
801: , rl.job_group_id
802: FROM
803: pa_resource_lists_all_bg rl,
804: pa_resource_list_members rlm,
805: pa_resource_txn_attributes rta,
806: pa_resources r,
807: pa_resource_types rt,
808: pa_resource_list_assignments rla

Line 825: pa_resource_list_members rlmc

821: AND NOT EXISTS
822: ( SELECT
823: 'Yes'
824: FROM
825: pa_resource_list_members rlmc
826: WHERE
827: rlmc.parent_member_id = rlm.resource_list_member_id
828: and nvl(rlmc.migration_code,'-99') <> 'N'
829: AND rlmc.enabled_flag = 'Y'

Line 855: pa_resource_list_members rlmc,

851: rtc.resource_type_code
852: , rl.job_group_id
853: FROM
854: pa_resource_lists_all_bg rl,
855: pa_resource_list_members rlmc,
856: pa_resource_list_members rlmp,
857: pa_resource_txn_attributes rtac,
858: pa_resource_txn_attributes rtap,
859: pa_resources rc,

Line 856: pa_resource_list_members rlmp,

852: , rl.job_group_id
853: FROM
854: pa_resource_lists_all_bg rl,
855: pa_resource_list_members rlmc,
856: pa_resource_list_members rlmp,
857: pa_resource_txn_attributes rtac,
858: pa_resource_txn_attributes rtap,
859: pa_resources rc,
860: pa_resource_types rtc,

Line 1959: PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;

1955: l_prev_txn_id NUMBER := NULL;
1956: l_counter NUMBER; /* Used by plsql tables during their population */
1957:
1958: TYPE l_resource_member_id_tbl_typ IS TABLE OF
1959: PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;
1960: TYPE l_resource_id_tbl_typ IS TABLE OF
1961: PA_RESOURCE_LIST_MEMBERS.RESOURCE_ID%TYPE;
1962: TYPE l_txn_id_table_typ IS TABLE OF PA_MAPPABLE_TXNS_TMP.TXN_ID%TYPE;
1963:

Line 1961: PA_RESOURCE_LIST_MEMBERS.RESOURCE_ID%TYPE;

1957:
1958: TYPE l_resource_member_id_tbl_typ IS TABLE OF
1959: PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE;
1960: TYPE l_resource_id_tbl_typ IS TABLE OF
1961: PA_RESOURCE_LIST_MEMBERS.RESOURCE_ID%TYPE;
1962: TYPE l_txn_id_table_typ IS TABLE OF PA_MAPPABLE_TXNS_TMP.TXN_ID%TYPE;
1963:
1964: l_resource_member_id_tbl L_RESOURCE_MEMBER_ID_TBL_TYP := L_RESOURCE_MEMBER_ID_TBL_TYP();
1965: l_resource_id_tbl L_RESOURCE_ID_TBL_TYP := L_RESOURCE_ID_TBL_TYP();

Line 2028: ,pa_resource_list_members prlm

2024: SELECT pmt.txn_id
2025: ,prlm.resource_list_member_id
2026: ,prlm.resource_id
2027: FROM pa_mappable_txns_tmp pmt
2028: ,pa_resource_list_members prlm
2029: WHERE pmt.resource_list_member_id is null /* A resource is not already assigned */
2030: AND pmt.parent_member_id is not null /* But a parent is assigned */
2031: AND pmt.parent_member_id = prlm.parent_member_id
2032: and nvl(prlm.migration_code,'-99') <> 'N'

Line 2061: ,pa_resource_list_members prlm

2057: , l_unclassified_res_id
2058: , l_rl_job_group_id
2059: , l_uncategorized_flag
2060: FROM pa_resource_lists_all_bg prl
2061: ,pa_resource_list_members prlm
2062: WHERE prl.resource_list_id = x_resource_list_id
2063: AND prl.resource_list_id = prlm.resource_list_id
2064: and nvl(prl.migration_code,'-99') <> 'N'
2065: and nvl(prlm.migration_code,'-99') <> 'N'

Line 2341: REVENUE_CATEGORY or EXPENDITURE_CATEGORY as NOT NULL, since PA_RESOURCE_LIST_MEMBERS

2337: delete from pa_resource_list_parents_tmp;
2338:
2339: /* PA_RESOURCE_LIST_PARENTS_TMP is a global temp table used by this process only.
2340: This table will have only one of the columns, either ORGANIZATION_ID or
2341: REVENUE_CATEGORY or EXPENDITURE_CATEGORY as NOT NULL, since PA_RESOURCE_LIST_MEMBERS
2342: can be grouped by any one of these three attributes only */
2343:
2344: /* Point 1.1 */
2345:

Line 2366: FROM pa_resource_list_members prlm

2362: ,prlm.resource_id
2363: ,prlm.organization_id
2364: ,prlm.expenditure_category
2365: ,prlm.revenue_category
2366: FROM pa_resource_list_members prlm
2367: WHERE prlm.parent_member_id is null
2368: AND prlm.resource_list_id = x_res_list_id
2369: and nvl(prlm.migration_code,'-99') <> 'N'
2370: AND prlm.enabled_flag = 'Y'

Line 2426: FROM pa_resource_list_members

2422: */
2423:
2424: CURSOR C3 IS
2425: SELECT DISTINCT resource_type_code
2426: FROM pa_resource_list_members
2427: WHERE resource_list_id = x_res_list_id
2428: and nvl(migration_code,'-99') <> 'N'
2429: AND parent_member_id is not null;
2430:

Line 2470: ,pa_resource_list_members prlm

2466: , prlm.resource_list_member_id
2467: , prlm.resource_id,
2468: prfr.rank
2469: FROM pa_mappable_txns_tmp temp
2470: ,pa_resource_list_members prlm
2471: ,pa_resource_format_ranks prfr
2472: WHERE temp.parent_member_id = prlm.parent_member_id
2473: AND prlm.person_id = temp.person_id
2474: AND prlm.resource_format_id = prfr.resource_format_id

Line 2500: ,pa_resource_list_members prlm

2496: , prlm.resource_list_member_id
2497: , prlm.resource_id,
2498: prfr.rank
2499: FROM pa_mappable_txns_tmp temp
2500: ,pa_resource_list_members prlm
2501: ,pa_resource_format_ranks prfr
2502: WHERE temp.parent_member_id = prlm.parent_member_id
2503: AND prlm.job_id = PA_Cross_Business_Grp.IsMappedToJob(temp.job_id,x_rl_job_grp_id)
2504: AND prlm.resource_format_id = prfr.resource_format_id

Line 2530: ,pa_resource_list_members PRLM

2526: , prlm.resource_list_member_id
2527: , prlm.resource_id
2528: , prfr.rank
2529: FROM pa_mappable_txns_tmp TEMP
2530: ,pa_resource_list_members PRLM
2531: ,pa_resource_format_ranks prfr
2532: WHERE temp.parent_member_id = prlm.parent_member_id
2533: AND prlm.organization_id = temp.organization_id
2534: AND prlm.resource_format_id = prfr.resource_format_id

Line 2560: ,pa_resource_list_members PRLM

2556: , prlm.resource_list_member_id
2557: , prlm.resource_id
2558: , prfr.rank
2559: FROM pa_mappable_txns_tmp TEMP
2560: ,pa_resource_list_members PRLM
2561: ,pa_resource_format_ranks prfr
2562: WHERE temp.parent_member_id = prlm.parent_member_id
2563: AND prlm.revenue_category = temp.revenue_category
2564: AND prlm.resource_format_id = prfr.resource_format_id

Line 2590: ,pa_resource_list_members PRLM

2586: , prlm.resource_list_member_id
2587: , prlm.resource_id
2588: , prfr.rank
2589: FROM pa_mappable_txns_tmp TEMP
2590: ,pa_resource_list_members PRLM
2591: ,pa_resource_format_ranks prfr
2592: WHERE temp.parent_member_id = prlm.parent_member_id
2593: AND prlm.vendor_id = temp.vendor_id
2594: AND prlm.resource_format_id = prfr.resource_format_id

Line 2620: ,pa_resource_list_members PRLM

2616: , prlm.resource_list_member_id
2617: , prlm.resource_id
2618: , prfr.rank
2619: FROM pa_mappable_txns_tmp TEMP
2620: ,pa_resource_list_members PRLM
2621: ,pa_resource_format_ranks prfr
2622: WHERE temp.parent_member_id = prlm.parent_member_id
2623: AND prlm.expenditure_type = temp.expenditure_type
2624: AND prlm.resource_format_id = prfr.resource_format_id

Line 2650: ,pa_resource_list_members PRLM

2646: , prlm.resource_list_member_id
2647: , prlm.resource_id
2648: , prfr.rank
2649: FROM pa_mappable_txns_tmp TEMP
2650: ,pa_resource_list_members PRLM
2651: ,pa_resource_format_ranks prfr
2652: WHERE temp.parent_member_id = prlm.parent_member_id
2653: AND prlm.expenditure_category = temp.expenditure_category
2654: AND prlm.resource_format_id = prfr.resource_format_id

Line 2680: ,pa_resource_list_members PRLM

2676: , prlm.resource_list_member_id
2677: , prlm.resource_id
2678: , prfr.rank
2679: FROM pa_mappable_txns_tmp TEMP
2680: ,pa_resource_list_members PRLM
2681: ,pa_resource_format_ranks prfr
2682: WHERE temp.parent_member_id = prlm.parent_member_id
2683: AND prlm.event_type = temp.event_type
2684: AND prlm.resource_format_id = prfr.resource_format_id

Line 2710: ,pa_resource_list_members PRLM

2706: , prlm.resource_list_member_id
2707: , prlm.resource_id
2708: , prfr.rank
2709: FROM pa_mappable_txns_tmp TEMP
2710: ,pa_resource_list_members PRLM
2711: ,pa_resource_format_ranks prfr
2712: WHERE temp.parent_member_id = prlm.parent_member_id
2713: AND prlm.project_role_id = temp.project_role_id
2714: AND prlm.resource_format_id = prfr.resource_format_id

Line 2751: FROM pa_resource_list_members

2747: */
2748:
2749: CURSOR C3 IS
2750: SELECT DISTINCT resource_type_code
2751: FROM pa_resource_list_members
2752: WHERE resource_list_id = x_res_list_id
2753: and nvl(migration_code,'-99') <> 'N';
2754:
2755: BEGIN

Line 2789: ,pa_resource_list_members PRLM

2785: , prlm.resource_list_member_id
2786: , prlm.resource_id
2787: , prfr.rank
2788: FROM pa_mappable_txns_tmp TEMP
2789: ,pa_resource_list_members PRLM
2790: ,pa_resource_format_ranks prfr
2791: WHERE prlm.person_id = temp.person_id
2792: AND prlm.resource_format_id = prfr.resource_format_id
2793: AND temp.resource_list_id = prlm.resource_list_id

Line 2818: ,pa_resource_list_members PRLM

2814: , prlm.resource_list_member_id
2815: , prlm.resource_id
2816: , prfr.rank
2817: FROM pa_mappable_txns_tmp TEMP
2818: ,pa_resource_list_members PRLM
2819: ,pa_resource_format_ranks prfr
2820: WHERE prlm.job_id = PA_Cross_Business_Grp.IsMappedToJob(temp.job_id,x_rl_job_grp_id)
2821: AND prlm.resource_format_id = prfr.resource_format_id
2822: AND temp.resource_list_id = prlm.resource_list_id

Line 2847: ,pa_resource_list_members PRLM

2843: , prlm.resource_list_member_id
2844: , prlm.resource_id
2845: , prfr.rank
2846: FROM pa_mappable_txns_tmp TEMP
2847: ,pa_resource_list_members PRLM
2848: ,pa_resource_format_ranks prfr
2849: WHERE prlm.organization_id = temp.organization_id
2850: AND prlm.resource_format_id = prfr.resource_format_id
2851: AND temp.resource_list_id = prlm.resource_list_id

Line 2876: ,pa_resource_list_members PRLM

2872: , prlm.resource_list_member_id
2873: , prlm.resource_id
2874: , prfr.rank
2875: FROM pa_mappable_txns_tmp TEMP
2876: ,pa_resource_list_members PRLM
2877: ,pa_resource_format_ranks prfr
2878: WHERE prlm.revenue_category = temp.revenue_category
2879: AND prlm.resource_format_id = prfr.resource_format_id
2880: AND temp.resource_list_id = prlm.resource_list_id

Line 2905: ,pa_resource_list_members PRLM

2901: , prlm.resource_list_member_id
2902: , prlm.resource_id
2903: , prfr.rank
2904: FROM pa_mappable_txns_tmp TEMP
2905: ,pa_resource_list_members PRLM
2906: ,pa_resource_format_ranks prfr
2907: WHERE prlm.vendor_id = temp.vendor_id
2908: AND prlm.resource_format_id = prfr.resource_format_id
2909: AND temp.resource_list_id = prlm.resource_list_id

Line 2934: ,pa_resource_list_members PRLM

2930: , prlm.resource_list_member_id
2931: , prlm.resource_id
2932: , prfr.rank
2933: FROM pa_mappable_txns_tmp TEMP
2934: ,pa_resource_list_members PRLM
2935: ,pa_resource_format_ranks prfr
2936: WHERE prlm.expenditure_type = temp.expenditure_type
2937: AND prlm.resource_format_id = prfr.resource_format_id
2938: AND temp.resource_list_id = prlm.resource_list_id

Line 2963: ,pa_resource_list_members PRLM

2959: , prlm.resource_list_member_id
2960: , prlm.resource_id
2961: , prfr.rank
2962: FROM pa_mappable_txns_tmp TEMP
2963: ,pa_resource_list_members PRLM
2964: ,pa_resource_format_ranks prfr
2965: WHERE prlm.expenditure_category = temp.expenditure_category
2966: AND prlm.resource_format_id = prfr.resource_format_id
2967: AND temp.resource_list_id = prlm.resource_list_id

Line 2992: ,pa_resource_list_members PRLM

2988: , prlm.resource_list_member_id
2989: , prlm.resource_id
2990: , prfr.rank
2991: FROM pa_mappable_txns_tmp TEMP
2992: ,pa_resource_list_members PRLM
2993: ,pa_resource_format_ranks prfr
2994: WHERE prlm.event_type = temp.event_type
2995: AND prlm.resource_format_id = prfr.resource_format_id
2996: AND temp.resource_list_id = prlm.resource_list_id

Line 3021: ,pa_resource_list_members PRLM

3017: , prlm.resource_list_member_id
3018: , prlm.resource_id
3019: , prfr.rank
3020: FROM pa_mappable_txns_tmp TEMP
3021: ,pa_resource_list_members PRLM
3022: ,pa_resource_format_ranks prfr
3023: WHERE prlm.project_role_id = temp.project_role_id
3024: AND prlm.resource_format_id = prfr.resource_format_id
3025: AND temp.resource_list_id = prlm.resource_list_id