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.PAY_HK_MPF dependencies on HRUSERDT

Line 95: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'

91: IF p_pay_basis <> 'Year' and
92: p_pay_basis <> 'Semi-Year' and
93: p_pay_basis <> 'Semi-Month' and /* Bug 7171659, based on Day rate times days*/
94: p_pay_basis <> 'Lunar Month' THEN
95: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
96: ,p_pay_basis,'Lower',l_period_end_date));
97: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
98: ,p_pay_basis,'Upper',l_period_end_date));
99: ELSIF p_pay_basis = 'Semi-Month' THEN /* Bug 7171659 */

Line 97: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'

93: p_pay_basis <> 'Semi-Month' and /* Bug 7171659, based on Day rate times days*/
94: p_pay_basis <> 'Lunar Month' THEN
95: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
96: ,p_pay_basis,'Lower',l_period_end_date));
97: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
98: ,p_pay_basis,'Upper',l_period_end_date));
99: ELSIF p_pay_basis = 'Semi-Month' THEN /* Bug 7171659 */
100: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
101: ,'Day','Lower',l_period_end_date))*(l_period_end_date-l_period_start_date+1);

Line 100: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'

96: ,p_pay_basis,'Lower',l_period_end_date));
97: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
98: ,p_pay_basis,'Upper',l_period_end_date));
99: ELSIF p_pay_basis = 'Semi-Month' THEN /* Bug 7171659 */
100: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
101: ,'Day','Lower',l_period_end_date))*(l_period_end_date-l_period_start_date+1);
102: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
103: ,'Day','Upper',l_period_end_date))*(l_period_end_date-l_period_start_date+1);
104: ELSIF p_pay_basis = 'Year' THEN

Line 102: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'

98: ,p_pay_basis,'Upper',l_period_end_date));
99: ELSIF p_pay_basis = 'Semi-Month' THEN /* Bug 7171659 */
100: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
101: ,'Day','Lower',l_period_end_date))*(l_period_end_date-l_period_start_date+1);
102: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
103: ,'Day','Upper',l_period_end_date))*(l_period_end_date-l_period_start_date+1);
104: ELSIF p_pay_basis = 'Year' THEN
105: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
106: ,'Calendar Month','Lower',l_period_end_date))*12;

Line 105: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'

101: ,'Day','Lower',l_period_end_date))*(l_period_end_date-l_period_start_date+1);
102: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
103: ,'Day','Upper',l_period_end_date))*(l_period_end_date-l_period_start_date+1);
104: ELSIF p_pay_basis = 'Year' THEN
105: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
106: ,'Calendar Month','Lower',l_period_end_date))*12;
107: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
108: ,'Calendar Month','Upper',l_period_end_date))*12;
109: ELSIF p_pay_basis = 'Semi-Year' THEN

Line 107: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'

103: ,'Day','Upper',l_period_end_date))*(l_period_end_date-l_period_start_date+1);
104: ELSIF p_pay_basis = 'Year' THEN
105: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
106: ,'Calendar Month','Lower',l_period_end_date))*12;
107: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
108: ,'Calendar Month','Upper',l_period_end_date))*12;
109: ELSIF p_pay_basis = 'Semi-Year' THEN
110: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
111: ,'Calendar Month','Lower',l_period_end_date))*6;

Line 110: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'

106: ,'Calendar Month','Lower',l_period_end_date))*12;
107: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
108: ,'Calendar Month','Upper',l_period_end_date))*12;
109: ELSIF p_pay_basis = 'Semi-Year' THEN
110: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
111: ,'Calendar Month','Lower',l_period_end_date))*6;
112: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
113: ,'Calendar Month','Upper',l_period_end_date))*6;
114: ELSIF p_pay_basis = 'Lunar Month' THEN

Line 112: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'

108: ,'Calendar Month','Upper',l_period_end_date))*12;
109: ELSIF p_pay_basis = 'Semi-Year' THEN
110: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
111: ,'Calendar Month','Lower',l_period_end_date))*6;
112: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
113: ,'Calendar Month','Upper',l_period_end_date))*6;
114: ELSIF p_pay_basis = 'Lunar Month' THEN
115: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
116: ,'Week','Lower',l_period_end_date))*4;

Line 115: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'

111: ,'Calendar Month','Lower',l_period_end_date))*6;
112: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
113: ,'Calendar Month','Upper',l_period_end_date))*6;
114: ELSIF p_pay_basis = 'Lunar Month' THEN
115: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
116: ,'Week','Lower',l_period_end_date))*4;
117: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
118: ,'Week','Upper',l_period_end_date))*4;
119: END IF;

Line 117: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'

113: ,'Calendar Month','Upper',l_period_end_date))*6;
114: ELSIF p_pay_basis = 'Lunar Month' THEN
115: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
116: ,'Week','Lower',l_period_end_date))*4;
117: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
118: ,'Week','Upper',l_period_end_date))*4;
119: END IF;
120: /*
121: ** Calculate Return Values based on p_calc_method and