APPS.PA_REP_UTIL_SCREEN dependencies on PA_REP_UTIL_SCREEN_TMP

Line 26: delete from PA_REP_UTIL_SCREEN_TMP;

22: )
23: IS
24: BEGIN
25:
26: delete from PA_REP_UTIL_SCREEN_TMP;
27:
28:
29: /*
30: * BEGINNING of Case 1 for U2

Line 35: INSERT INTO PA_REP_UTIL_SCREEN_TMP (

31: * GE view
32: */
33: IF (p_Period_Type=PA_REP_UTIL_GLOB.GetPeriodTypeGe) THEN
34:
35: INSERT INTO PA_REP_UTIL_SCREEN_TMP (
36: Organization_id
37: , Person_id
38: , Resource_id
39: , Resource_Name

Line 722: INSERT INTO PA_REP_UTIL_SCREEN_TMP (

718: */
719: IF (p_Period_Type=PA_REP_UTIL_GLOB.GetPeriodTypeGl OR
720: p_Period_Type=PA_REP_UTIL_GLOB.GetPeriodTypePa) THEN
721:
722: INSERT INTO PA_REP_UTIL_SCREEN_TMP (
723: Organization_id
724: , Person_id
725: , Resource_id
726: , Resource_Name

Line 1411: INSERT INTO PA_REP_UTIL_SCREEN_TMP (

1407: * QR view
1408: */
1409: IF (p_Period_Type=PA_REP_UTIL_GLOB.GetPeriodTypeQr) THEN
1410:
1411: INSERT INTO PA_REP_UTIL_SCREEN_TMP (
1412: Organization_id
1413: , Person_id
1414: , Resource_id
1415: , Resource_Name

Line 2117: INSERT INTO PA_REP_UTIL_SCREEN_TMP (

2113: * YR view
2114: */
2115: IF (p_Period_Type=PA_REP_UTIL_GLOB.GetPeriodTypeYr) THEN
2116:
2117: INSERT INTO PA_REP_UTIL_SCREEN_TMP (
2118: Organization_id
2119: , Person_id
2120: , Resource_id
2121: , Resource_Name

Line 2822: Update PA_REP_UTIL_SCREEN_TMP tmp

2818: * of EMPLOYEE for all the records now check against pa_resources_denorm
2819: * to update the resource_type_code to MANAGERS appropriately.
2820: */
2821:
2822: Update PA_REP_UTIL_SCREEN_TMP tmp
2823: Set (resource_type,resource_type_code) = (select lkup2.meaning,lkup2.lookup_code
2824: from pa_lookups lkup2
2825: where lkup2.lookup_type='PERSON_TYPE'
2826: and lkup2.lookup_code = 'MANAGER')