DBA Data[Home] [Help]

APPS.PA_REP_UTILS_SUMM_PKG dependencies on PA_AMOUNT_TYPES_B

Line 30: l_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE

26:
27: /*
28: * Cache Amount Type Id.
29: */
30: l_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
31: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_hrs_id;
32: l_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
33: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_prvhrs_id;
34: l_tot_wght_hrs_people_id pa_amount_types_b.amount_type_id%TYPE

Line 32: l_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE

28: * Cache Amount Type Id.
29: */
30: l_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
31: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_hrs_id;
32: l_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
33: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_prvhrs_id;
34: l_tot_wght_hrs_people_id pa_amount_types_b.amount_type_id%TYPE
35: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_wtdhrs_people_id;
36: l_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE

Line 34: l_tot_wght_hrs_people_id pa_amount_types_b.amount_type_id%TYPE

30: l_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
31: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_hrs_id;
32: l_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
33: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_prvhrs_id;
34: l_tot_wght_hrs_people_id pa_amount_types_b.amount_type_id%TYPE
35: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_wtdhrs_people_id;
36: l_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
37: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_wtdhrs_org_id;
38: l_prov_wght_hrs_people_id pa_amount_types_b.amount_type_id%TYPE

Line 36: l_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE

32: l_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
33: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_prvhrs_id;
34: l_tot_wght_hrs_people_id pa_amount_types_b.amount_type_id%TYPE
35: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_wtdhrs_people_id;
36: l_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
37: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_wtdhrs_org_id;
38: l_prov_wght_hrs_people_id pa_amount_types_b.amount_type_id%TYPE
39: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_prvwtdhrs_people_id;
40: l_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE

Line 38: l_prov_wght_hrs_people_id pa_amount_types_b.amount_type_id%TYPE

34: l_tot_wght_hrs_people_id pa_amount_types_b.amount_type_id%TYPE
35: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_wtdhrs_people_id;
36: l_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
37: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_wtdhrs_org_id;
38: l_prov_wght_hrs_people_id pa_amount_types_b.amount_type_id%TYPE
39: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_prvwtdhrs_people_id;
40: l_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
41: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_prvwtdhrs_org_id;
42: l_red_cap_id pa_amount_types_b.amount_type_id%TYPE

Line 40: l_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE

36: l_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
37: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_wtdhrs_org_id;
38: l_prov_wght_hrs_people_id pa_amount_types_b.amount_type_id%TYPE
39: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_prvwtdhrs_people_id;
40: l_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
41: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_prvwtdhrs_org_id;
42: l_red_cap_id pa_amount_types_b.amount_type_id%TYPE
43: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_reducedcap_id;
44: l_tot_cap_id pa_amount_types_b.amount_type_id%TYPE

Line 42: l_red_cap_id pa_amount_types_b.amount_type_id%TYPE

38: l_prov_wght_hrs_people_id pa_amount_types_b.amount_type_id%TYPE
39: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_prvwtdhrs_people_id;
40: l_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
41: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_prvwtdhrs_org_id;
42: l_red_cap_id pa_amount_types_b.amount_type_id%TYPE
43: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_reducedcap_id;
44: l_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
45: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id;
46: /*

Line 44: l_tot_cap_id pa_amount_types_b.amount_type_id%TYPE

40: l_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
41: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_prvwtdhrs_org_id;
42: l_red_cap_id pa_amount_types_b.amount_type_id%TYPE
43: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_reducedcap_id;
44: l_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
45: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id;
46: /*
47: * End Caching.
48: */

Line 109: l_dirct_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE

105:
106: /*
107: * Cache org level direct amount type Id.
108: */
109: l_dirct_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
110: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_hrs_id;
111: l_dirct_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
112: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_prvhrs_id;
113: l_dirct_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE

Line 111: l_dirct_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE

107: * Cache org level direct amount type Id.
108: */
109: l_dirct_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
110: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_hrs_id;
111: l_dirct_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
112: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_prvhrs_id;
113: l_dirct_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
114: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_wtdhrs_org_id;
115: l_dirct_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE

Line 113: l_dirct_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE

109: l_dirct_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
110: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_hrs_id;
111: l_dirct_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
112: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_prvhrs_id;
113: l_dirct_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
114: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_wtdhrs_org_id;
115: l_dirct_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
116: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_prvwtdhrs_org_id;
117: l_dirct_cap_id pa_amount_types_b.amount_type_id%TYPE

Line 115: l_dirct_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE

111: l_dirct_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
112: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_prvhrs_id;
113: l_dirct_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
114: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_wtdhrs_org_id;
115: l_dirct_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
116: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_prvwtdhrs_org_id;
117: l_dirct_cap_id pa_amount_types_b.amount_type_id%TYPE
118: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_cap_id;
119: l_dirct_reduce_cap_id pa_amount_types_b.amount_type_id%TYPE

Line 117: l_dirct_cap_id pa_amount_types_b.amount_type_id%TYPE

113: l_dirct_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
114: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_wtdhrs_org_id;
115: l_dirct_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
116: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_prvwtdhrs_org_id;
117: l_dirct_cap_id pa_amount_types_b.amount_type_id%TYPE
118: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_cap_id;
119: l_dirct_reduce_cap_id pa_amount_types_b.amount_type_id%TYPE
120: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_reducedcap_id;
121: /*

Line 119: l_dirct_reduce_cap_id pa_amount_types_b.amount_type_id%TYPE

115: l_dirct_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
116: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_prvwtdhrs_org_id;
117: l_dirct_cap_id pa_amount_types_b.amount_type_id%TYPE
118: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_cap_id;
119: l_dirct_reduce_cap_id pa_amount_types_b.amount_type_id%TYPE
120: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_reducedcap_id;
121: /*
122: * End Cache org level direct amount type Id.
123: */

Line 2466: l_tot_cap_id pa_amount_types_b.amount_type_id%TYPE

2462: L_PERIOD_YEAR_TAB PA_PLSQL_DATATYPES.NumTabTyp;
2463: L_QUARTER_OR_MONTH_NUMBER_TAB PA_PLSQL_DATATYPES.NumTabTyp;
2464: L_AMOUNT_TYPE_ID_TAB PA_PLSQL_DATATYPES.IdTabTyp;
2465:
2466: l_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
2467: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id;
2468: l_dirct_cap_id pa_amount_types_b.amount_type_id%TYPE
2469: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_cap_id;
2470: l_sub_org_cap_id pa_amount_types_b.amount_type_id%TYPE

Line 2468: l_dirct_cap_id pa_amount_types_b.amount_type_id%TYPE

2464: L_AMOUNT_TYPE_ID_TAB PA_PLSQL_DATATYPES.IdTabTyp;
2465:
2466: l_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
2467: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id;
2468: l_dirct_cap_id pa_amount_types_b.amount_type_id%TYPE
2469: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_cap_id;
2470: l_sub_org_cap_id pa_amount_types_b.amount_type_id%TYPE
2471: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_cap_id;
2472: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE

Line 2470: l_sub_org_cap_id pa_amount_types_b.amount_type_id%TYPE

2466: l_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
2467: := PA_REP_UTIL_GLOB.G_amt_type_details.G_res_cap_id;
2468: l_dirct_cap_id pa_amount_types_b.amount_type_id%TYPE
2469: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_cap_id;
2470: l_sub_org_cap_id pa_amount_types_b.amount_type_id%TYPE
2471: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_cap_id;
2472: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
2473: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_cap_id;
2474:

Line 2472: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE

2468: l_dirct_cap_id pa_amount_types_b.amount_type_id%TYPE
2469: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_dir_cap_id;
2470: l_sub_org_cap_id pa_amount_types_b.amount_type_id%TYPE
2471: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_cap_id;
2472: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
2473: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_cap_id;
2474:
2475: l_totally_fetched NUMBER := 0;
2476:

Line 2696: l_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE

2692: IS
2693: /*
2694: * Cache sub org and total level amount types.
2695: */
2696: l_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
2697: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_hrs_id;
2698: l_org_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2699: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_wtdhrs_org_id;
2700: l_org_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE

Line 2698: l_org_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE

2694: * Cache sub org and total level amount types.
2695: */
2696: l_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
2697: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_hrs_id;
2698: l_org_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2699: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_wtdhrs_org_id;
2700: l_org_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
2701: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_prvhrs_id;
2702: l_org_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE

Line 2700: l_org_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE

2696: l_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
2697: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_hrs_id;
2698: l_org_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2699: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_wtdhrs_org_id;
2700: l_org_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
2701: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_prvhrs_id;
2702: l_org_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2703: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_prvwtdhrs_org_id;
2704: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE

Line 2702: l_org_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE

2698: l_org_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2699: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_wtdhrs_org_id;
2700: l_org_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
2701: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_prvhrs_id;
2702: l_org_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2703: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_prvwtdhrs_org_id;
2704: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
2705: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_cap_id;
2706: l_org_tot_reducedcap_id pa_amount_types_b.amount_type_id%TYPE

Line 2704: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE

2700: l_org_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
2701: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_prvhrs_id;
2702: l_org_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2703: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_prvwtdhrs_org_id;
2704: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
2705: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_cap_id;
2706: l_org_tot_reducedcap_id pa_amount_types_b.amount_type_id%TYPE
2707: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_reducedcap_id;
2708: l_sub_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE

Line 2706: l_org_tot_reducedcap_id pa_amount_types_b.amount_type_id%TYPE

2702: l_org_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2703: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_prvwtdhrs_org_id;
2704: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
2705: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_cap_id;
2706: l_org_tot_reducedcap_id pa_amount_types_b.amount_type_id%TYPE
2707: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_reducedcap_id;
2708: l_sub_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
2709: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_hrs_id;
2710: l_sub_org_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE

Line 2708: l_sub_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE

2704: l_org_tot_cap_id pa_amount_types_b.amount_type_id%TYPE
2705: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_cap_id;
2706: l_org_tot_reducedcap_id pa_amount_types_b.amount_type_id%TYPE
2707: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_reducedcap_id;
2708: l_sub_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
2709: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_hrs_id;
2710: l_sub_org_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
2711: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_prvhrs_id;
2712: l_sub_org_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE

Line 2710: l_sub_org_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE

2706: l_org_tot_reducedcap_id pa_amount_types_b.amount_type_id%TYPE
2707: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_tot_reducedcap_id;
2708: l_sub_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
2709: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_hrs_id;
2710: l_sub_org_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
2711: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_prvhrs_id;
2712: l_sub_org_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2713: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_wtdhrs_org_id;
2714: l_sub_org_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE

Line 2712: l_sub_org_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE

2708: l_sub_org_tot_hrs_id pa_amount_types_b.amount_type_id%TYPE
2709: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_hrs_id;
2710: l_sub_org_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
2711: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_prvhrs_id;
2712: l_sub_org_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2713: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_wtdhrs_org_id;
2714: l_sub_org_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2715: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_prvwtdhrs_org_id;
2716: l_sub_org_cap_id pa_amount_types_b.amount_type_id%TYPE

Line 2714: l_sub_org_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE

2710: l_sub_org_tot_prov_hrs_id pa_amount_types_b.amount_type_id%TYPE
2711: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_prvhrs_id;
2712: l_sub_org_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2713: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_wtdhrs_org_id;
2714: l_sub_org_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2715: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_prvwtdhrs_org_id;
2716: l_sub_org_cap_id pa_amount_types_b.amount_type_id%TYPE
2717: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_cap_id;
2718: l_sub_org_reducedcap_id pa_amount_types_b.amount_type_id%TYPE

Line 2716: l_sub_org_cap_id pa_amount_types_b.amount_type_id%TYPE

2712: l_sub_org_tot_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2713: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_wtdhrs_org_id;
2714: l_sub_org_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2715: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_prvwtdhrs_org_id;
2716: l_sub_org_cap_id pa_amount_types_b.amount_type_id%TYPE
2717: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_cap_id;
2718: l_sub_org_reducedcap_id pa_amount_types_b.amount_type_id%TYPE
2719: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_reducedcap_id;
2720: /** End Cache sub org and total level amount types **/

Line 2718: l_sub_org_reducedcap_id pa_amount_types_b.amount_type_id%TYPE

2714: l_sub_org_prov_wght_hrs_org_id pa_amount_types_b.amount_type_id%TYPE
2715: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_prvwtdhrs_org_id;
2716: l_sub_org_cap_id pa_amount_types_b.amount_type_id%TYPE
2717: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_cap_id;
2718: l_sub_org_reducedcap_id pa_amount_types_b.amount_type_id%TYPE
2719: := PA_REP_UTIL_GLOB.G_amt_type_details.G_org_sub_reducedcap_id;
2720: /** End Cache sub org and total level amount types **/
2721:
2722: