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 116: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'

112: IF p_pay_basis <> 'Year' and
113: p_pay_basis <> 'Semi-Year' and
114: p_pay_basis <> 'Semi-Month' and /* Bug 7171659, based on Day rate times days*/
115: p_pay_basis <> 'Lunar Month' THEN
116: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
117: ,p_pay_basis,'Lower',l_period_start_date));
118: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
119: ,p_pay_basis,'Upper',l_period_start_date));
120: ELSIF p_pay_basis = 'Semi-Month' THEN /* Bug 7171659 */

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

114: p_pay_basis <> 'Semi-Month' and /* Bug 7171659, based on Day rate times days*/
115: p_pay_basis <> 'Lunar Month' THEN
116: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
117: ,p_pay_basis,'Lower',l_period_start_date));
118: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
119: ,p_pay_basis,'Upper',l_period_start_date));
120: ELSIF p_pay_basis = 'Semi-Month' THEN /* Bug 7171659 */
121: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
122: ,'Day','Lower',l_period_start_date))*(l_period_end_date-l_period_start_date+1);

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

117: ,p_pay_basis,'Lower',l_period_start_date));
118: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
119: ,p_pay_basis,'Upper',l_period_start_date));
120: ELSIF p_pay_basis = 'Semi-Month' THEN /* Bug 7171659 */
121: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
122: ,'Day','Lower',l_period_start_date))*(l_period_end_date-l_period_start_date+1);
123: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
124: ,'Day','Upper',l_period_start_date))*(l_period_end_date-l_period_start_date+1);
125: ELSIF p_pay_basis = 'Year' THEN

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

119: ,p_pay_basis,'Upper',l_period_start_date));
120: ELSIF p_pay_basis = 'Semi-Month' THEN /* Bug 7171659 */
121: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
122: ,'Day','Lower',l_period_start_date))*(l_period_end_date-l_period_start_date+1);
123: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
124: ,'Day','Upper',l_period_start_date))*(l_period_end_date-l_period_start_date+1);
125: ELSIF p_pay_basis = 'Year' THEN
126: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
127: ,'Calendar Month','Lower',l_period_start_date))*12;

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

122: ,'Day','Lower',l_period_start_date))*(l_period_end_date-l_period_start_date+1);
123: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
124: ,'Day','Upper',l_period_start_date))*(l_period_end_date-l_period_start_date+1);
125: ELSIF p_pay_basis = 'Year' THEN
126: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
127: ,'Calendar Month','Lower',l_period_start_date))*12;
128: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
129: ,'Calendar Month','Upper',l_period_start_date))*12;
130: ELSIF p_pay_basis = 'Semi-Year' THEN

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

124: ,'Day','Upper',l_period_start_date))*(l_period_end_date-l_period_start_date+1);
125: ELSIF p_pay_basis = 'Year' THEN
126: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
127: ,'Calendar Month','Lower',l_period_start_date))*12;
128: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
129: ,'Calendar Month','Upper',l_period_start_date))*12;
130: ELSIF p_pay_basis = 'Semi-Year' THEN
131: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
132: ,'Calendar Month','Lower',l_period_start_date))*6;

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

127: ,'Calendar Month','Lower',l_period_start_date))*12;
128: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
129: ,'Calendar Month','Upper',l_period_start_date))*12;
130: ELSIF p_pay_basis = 'Semi-Year' THEN
131: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
132: ,'Calendar Month','Lower',l_period_start_date))*6;
133: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
134: ,'Calendar Month','Upper',l_period_start_date))*6;
135: ELSIF p_pay_basis = 'Lunar Month' THEN

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

129: ,'Calendar Month','Upper',l_period_start_date))*12;
130: ELSIF p_pay_basis = 'Semi-Year' THEN
131: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
132: ,'Calendar Month','Lower',l_period_start_date))*6;
133: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
134: ,'Calendar Month','Upper',l_period_start_date))*6;
135: ELSIF p_pay_basis = 'Lunar Month' THEN
136: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
137: ,'Week','Lower',l_period_start_date))*4;

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

132: ,'Calendar Month','Lower',l_period_start_date))*6;
133: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
134: ,'Calendar Month','Upper',l_period_start_date))*6;
135: ELSIF p_pay_basis = 'Lunar Month' THEN
136: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
137: ,'Week','Lower',l_period_start_date))*4;
138: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
139: ,'Week','Upper',l_period_start_date))*4;
140: END IF;

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

134: ,'Calendar Month','Upper',l_period_start_date))*6;
135: ELSIF p_pay_basis = 'Lunar Month' THEN
136: l_min_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
137: ,'Week','Lower',l_period_start_date))*4;
138: l_max_ri := to_number(hruserdt.get_table_value(p_bus_grp_id,'MPF_RI_LIMITS'
139: ,'Week','Upper',l_period_start_date))*4;
140: END IF;
141: /*
142: ** Calculate Return Values based on p_calc_method and