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_PLANNING_RESOURCE_UTILS dependencies on PA_LOOKUPS

Line 1557: FROM pa_lookups

1553: ELSIF p_res_type_code = 'PERSON_TYPE' THEN
1554: BEGIN
1555: SELECT lookup_code
1556: INTO x_person_type_code
1557: FROM pa_lookups
1558: WHERE lookup_type = 'PA_PERSON_TYPE'
1559: AND lookup_code = p_resource_code;
1560: EXCEPTION
1561: WHEN OTHERS THEN

Line 2952: pa_lookups

2948: Cursor c_PersonType (P_Person_Type IN Varchar2) Is
2949: Select
2950: Meaning
2951: From
2952: pa_lookups
2953: Where
2954: Lookup_Type = 'PA_PERSON_TYPE'
2955: And Lookup_Code = P_Person_Type;
2956:

Line 3631: FROM PA_LOOKUPS lk

3627: BEGIN
3628:
3629: SELECT lk.Meaning
3630: INTO l_Fin_Cat_Displayed
3631: FROM PA_LOOKUPS lk
3632: WHERE lk.Lookup_Type = 'REVENUE CATEGORY'
3633: and lk.lookup_code = l_revenue_category_code;
3634:
3635: EXCEPTION

Line 5027: Pa_Lookups

5023: Cursor c_Rev_Cat_Code ( P_Fin_Cat_Code IN Varchar2) Is
5024: Select
5025: Meaning
5026: From
5027: Pa_Lookups
5028: Where
5029: Lookup_Code = P_Fin_Cat_Code
5030: And Lookup_Type = 'REVENUE CATEGORY';
5031:

Line 5036: Pa_Lookups

5032: Cursor c_Rev_Cat_Meaning ( P_Fin_Cat_Meaning IN Varchar2) Is
5033: Select
5034: lookup_code
5035: From
5036: Pa_Lookups
5037: Where
5038: Meaning = P_Fin_Cat_Meaning
5039: And Lookup_Type = 'REVENUE CATEGORY';
5040: