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_FORMAT_RANKS

Line 534: pa_resource_format_ranks

530: rank
531: INTO
532: x_rank
533: FROM
534: pa_resource_format_ranks
535: WHERE
536: resource_format_id = x_resource_format_id
537: AND txn_class_code = x_txn_class_code;
538:

Line 2471: ,pa_resource_format_ranks prfr

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
2475: and prlm.resource_list_id = x_res_list_id

Line 2501: ,pa_resource_format_ranks prfr

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
2505: and prlm.resource_list_id = x_res_list_id

Line 2531: ,pa_resource_format_ranks prfr

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
2535: and prlm.resource_list_id = x_res_list_id

Line 2561: ,pa_resource_format_ranks prfr

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
2565: and prlm.resource_list_id = x_res_list_id

Line 2591: ,pa_resource_format_ranks prfr

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
2595: and prlm.resource_list_id = x_res_list_id

Line 2621: ,pa_resource_format_ranks prfr

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
2625: and prlm.resource_list_id = x_res_list_id

Line 2651: ,pa_resource_format_ranks prfr

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
2655: and prlm.resource_list_id = x_res_list_id

Line 2681: ,pa_resource_format_ranks prfr

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
2685: and prlm.resource_list_id = x_res_list_id

Line 2711: ,pa_resource_format_ranks prfr

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
2715: and prlm.resource_list_id = x_res_list_id

Line 2790: ,pa_resource_format_ranks prfr

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
2794: and prlm.resource_list_id = x_res_list_id

Line 2819: ,pa_resource_format_ranks prfr

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
2823: and prlm.resource_list_id = x_res_list_id

Line 2848: ,pa_resource_format_ranks prfr

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
2852: and prlm.resource_list_id = x_res_list_id

Line 2877: ,pa_resource_format_ranks prfr

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
2881: and prlm.resource_list_id = x_res_list_id

Line 2906: ,pa_resource_format_ranks prfr

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
2910: and prlm.resource_list_id = x_res_list_id

Line 2935: ,pa_resource_format_ranks prfr

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
2939: and prlm.resource_list_id = x_res_list_id

Line 2964: ,pa_resource_format_ranks prfr

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
2968: and prlm.resource_list_id = x_res_list_id

Line 2993: ,pa_resource_format_ranks prfr

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
2997: and prlm.resource_list_id = x_res_list_id

Line 3022: ,pa_resource_format_ranks prfr

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
3026: and prlm.resource_list_id = x_res_list_id