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.PQP_PENSION_FUNCTIONS dependencies on PAY_NL_SI_PKG

Line 1070: pay_nl_si_pkg.Get_Max_SI_Days(p_assignment_id,l_pay_start_dt,l_pay_end_dt);

1066: CLOSE c_get_work_pattern;
1067: l_ret_val := 3;
1068: END IF;
1069: l_max_si_days :=
1070: pay_nl_si_pkg.Get_Max_SI_Days(p_assignment_id,l_pay_start_dt,l_pay_end_dt);
1071: ELSE
1072: l_max_si_days :=
1073: pay_nl_si_pkg.Get_Week_Days(l_pay_start_dt,l_pay_end_dt);
1074: END IF;

Line 1073: pay_nl_si_pkg.Get_Week_Days(l_pay_start_dt,l_pay_end_dt);

1069: l_max_si_days :=
1070: pay_nl_si_pkg.Get_Max_SI_Days(p_assignment_id,l_pay_start_dt,l_pay_end_dt);
1071: ELSE
1072: l_max_si_days :=
1073: pay_nl_si_pkg.Get_Week_Days(l_pay_start_dt,l_pay_end_dt);
1074: END IF;
1075: l_average_days_multiplier :=
1076: l_max_si_days * l_overridden_avgsi_assignment/100;
1077:

Line 1293: -- l_max_si_days := pay_nl_si_pkg.Get_Max_SI_Days(p_assignment_id,l_pay_start_dt,l_pay_end_dt);

1289: l_average_days_multiplier := (l_average_days_multiplier/l_payroll_days * l_actual_work_days);
1290: END IF;
1291:
1292: ELSIF (l_override_method = 2 ) THEN -- 'Percentage of Maximum Days'
1293: -- l_max_si_days := pay_nl_si_pkg.Get_Max_SI_Days(p_assignment_id,l_pay_start_dt,l_pay_end_dt);
1294: -- l_average_days_multiplier := l_max_si_days * l_overridden_avgsi_assignment /100;
1295: --bug 3115132
1296: --get the method for maximum si days from social insurance tab
1297: OPEN c_get_max_si_values(p_assignment_id,p_date_earned);

Line 1314: pay_nl_si_pkg.Get_Max_SI_Days(p_assignment_id,l_pay_start_dt,l_pay_end_dt);

1310: CLOSE c_get_work_pattern;
1311: l_ret_val := 3;
1312: END IF;
1313: l_max_si_days :=
1314: pay_nl_si_pkg.Get_Max_SI_Days(p_assignment_id,l_pay_start_dt,l_pay_end_dt);
1315: ELSE
1316: l_max_si_days :=
1317: pay_nl_si_pkg.Get_Week_Days(l_pay_start_dt,l_pay_end_dt);
1318: END IF;

Line 1317: pay_nl_si_pkg.Get_Week_Days(l_pay_start_dt,l_pay_end_dt);

1313: l_max_si_days :=
1314: pay_nl_si_pkg.Get_Max_SI_Days(p_assignment_id,l_pay_start_dt,l_pay_end_dt);
1315: ELSE
1316: l_max_si_days :=
1317: pay_nl_si_pkg.Get_Week_Days(l_pay_start_dt,l_pay_end_dt);
1318: END IF;
1319: l_average_days_multiplier :=
1320: l_max_si_days * l_overridden_avgsi_assignment/100;
1321:

Line 1372: l_working_work_pattern_days := pay_nl_si_pkg.Get_Working_Work_Pattern_days(p_assignment_id) ;

1368: IF l_debug THEN
1369: pqp_utilities.debug(' l_work_pattern is '|| l_work_pattern , 190);
1370: END IF;
1371:
1372: l_working_work_pattern_days := pay_nl_si_pkg.Get_Working_Work_Pattern_days(p_assignment_id) ;
1373: l_total_work_pattern_days := pay_nl_si_pkg.Get_Total_Work_Pattern_days(p_assignment_id) ;
1374:
1375: IF l_debug THEN
1376: pqp_utilities.debug(' l_working_work_pattern_days is '|| l_working_work_pattern_days , 200);

Line 1373: l_total_work_pattern_days := pay_nl_si_pkg.Get_Total_Work_Pattern_days(p_assignment_id) ;

1369: pqp_utilities.debug(' l_work_pattern is '|| l_work_pattern , 190);
1370: END IF;
1371:
1372: l_working_work_pattern_days := pay_nl_si_pkg.Get_Working_Work_Pattern_days(p_assignment_id) ;
1373: l_total_work_pattern_days := pay_nl_si_pkg.Get_Total_Work_Pattern_days(p_assignment_id) ;
1374:
1375: IF l_debug THEN
1376: pqp_utilities.debug(' l_working_work_pattern_days is '|| l_working_work_pattern_days , 200);
1377: pqp_utilities.debug(' l_total_work_pattern_days is '|| l_total_work_pattern_days , 210);

Line 1435: l_non_si_days := pay_nl_si_pkg.Get_Non_SI_Days(p_assignment_id,l_pay_start_dt,l_pay_end_dt);

1431: pqp_utilities.debug(' l_average_ws_si_days is '|| l_average_ws_si_days , 225);
1432: END IF;
1433:
1434: -- get non si days
1435: l_non_si_days := pay_nl_si_pkg.Get_Non_SI_Days(p_assignment_id,l_pay_start_dt,l_pay_end_dt);
1436:
1437: IF l_debug THEN
1438: pqp_utilities.debug(' l_non_si_days is '|| l_non_si_days , 230);
1439: END IF;

Line 1606: l_max_si_days := pay_nl_si_pkg.Get_Max_SI_Days(p_assignment_id,l_pay_start_dt,l_pay_end_dt);

1602: pqp_utilities.debug(' l_working_work_pattern_days is '|| l_working_work_pattern_days , 50);
1603: END IF;
1604:
1605: IF (l_max_si_method = 0 ) THEN -- 1 indicates 'Payroll Period' 0 indicates Weeks worked.
1606: l_max_si_days := pay_nl_si_pkg.Get_Max_SI_Days(p_assignment_id,l_pay_start_dt,l_pay_end_dt);
1607: ELSE
1608: l_max_si_days := pay_nl_si_pkg.Get_Week_Days(l_pay_start_dt,l_pay_end_dt);
1609: END IF;
1610:

Line 1608: l_max_si_days := pay_nl_si_pkg.Get_Week_Days(l_pay_start_dt,l_pay_end_dt);

1604:
1605: IF (l_max_si_method = 0 ) THEN -- 1 indicates 'Payroll Period' 0 indicates Weeks worked.
1606: l_max_si_days := pay_nl_si_pkg.Get_Max_SI_Days(p_assignment_id,l_pay_start_dt,l_pay_end_dt);
1607: ELSE
1608: l_max_si_days := pay_nl_si_pkg.Get_Week_Days(l_pay_start_dt,l_pay_end_dt);
1609: END IF;
1610:
1611: IF l_debug THEN
1612: pqp_utilities.debug(' l_max_si_days is '|| l_max_si_days , 60);

Line 1615: l_non_si_days := pay_nl_si_pkg.Get_Non_SI_Days(p_assignment_id,l_pay_start_dt,l_pay_end_dt);

1611: IF l_debug THEN
1612: pqp_utilities.debug(' l_max_si_days is '|| l_max_si_days , 60);
1613: END IF;
1614:
1615: l_non_si_days := pay_nl_si_pkg.Get_Non_SI_Days(p_assignment_id,l_pay_start_dt,l_pay_end_dt);
1616:
1617: IF l_debug THEN
1618: pqp_utilities.debug(' l_non_si_days is '|| l_non_si_days , 70);
1619: END IF;

Line 3621: l_fte := pay_nl_si_pkg.get_part_time_perc( l_assignment_id

3617: -- Call function to check if the user has overridden the part
3618: -- time percentage . If a value is found , use this to derive the
3619: -- FTE
3620: --
3621: l_fte := pay_nl_si_pkg.get_part_time_perc( l_assignment_id
3622: ,p_date_earned
3623: ,p_business_group_id
3624: ,p_assignment_action_id);
3625:

Line 3649: l_fte := pay_nl_si_pkg.get_part_time_perc( p_assignment_id

3645: -- Call function to check if the user has overridden the part
3646: -- time percentage . If a value is found , use this to derive the
3647: -- FTE
3648: --
3649: l_fte := pay_nl_si_pkg.get_part_time_perc( p_assignment_id
3650: ,p_date_earned
3651: ,p_business_group_id
3652: ,p_assignment_action_id);
3653: