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 1135: pay_nl_si_pkg.Get_Max_SI_Days(p_assignment_id,l_pay_start_dt,l_pay_end_dt);

1131: CLOSE c_get_work_pattern;
1132: l_ret_val := 3;
1133: END IF;
1134: l_max_si_days :=
1135: pay_nl_si_pkg.Get_Max_SI_Days(p_assignment_id,l_pay_start_dt,l_pay_end_dt);
1136: ELSE
1137: l_max_si_days :=
1138: pay_nl_si_pkg.Get_Week_Days(l_pay_start_dt,l_pay_end_dt);
1139: END IF;

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

1134: l_max_si_days :=
1135: pay_nl_si_pkg.Get_Max_SI_Days(p_assignment_id,l_pay_start_dt,l_pay_end_dt);
1136: ELSE
1137: l_max_si_days :=
1138: pay_nl_si_pkg.Get_Week_Days(l_pay_start_dt,l_pay_end_dt);
1139: END IF;
1140: l_average_days_multiplier :=
1141: l_max_si_days * l_overridden_avgsi_assignment/100;
1142:

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

1354: l_average_days_multiplier := (l_average_days_multiplier/l_payroll_days * l_actual_work_days);
1355: END IF;
1356:
1357: ELSIF (l_override_method = 2 ) THEN -- 'Percentage of Maximum Days'
1358: -- l_max_si_days := pay_nl_si_pkg.Get_Max_SI_Days(p_assignment_id,l_pay_start_dt,l_pay_end_dt);
1359: -- l_average_days_multiplier := l_max_si_days * l_overridden_avgsi_assignment /100;
1360: --bug 3115132
1361: --get the method for maximum si days from social insurance tab
1362: OPEN c_get_max_si_values(p_assignment_id,p_date_earned);

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

1375: CLOSE c_get_work_pattern;
1376: l_ret_val := 3;
1377: END IF;
1378: l_max_si_days :=
1379: pay_nl_si_pkg.Get_Max_SI_Days(p_assignment_id,l_pay_start_dt,l_pay_end_dt);
1380: ELSE
1381: l_max_si_days :=
1382: pay_nl_si_pkg.Get_Week_Days(l_pay_start_dt,l_pay_end_dt);
1383: END IF;

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

1378: l_max_si_days :=
1379: pay_nl_si_pkg.Get_Max_SI_Days(p_assignment_id,l_pay_start_dt,l_pay_end_dt);
1380: ELSE
1381: l_max_si_days :=
1382: pay_nl_si_pkg.Get_Week_Days(l_pay_start_dt,l_pay_end_dt);
1383: END IF;
1384: l_average_days_multiplier :=
1385: l_max_si_days * l_overridden_avgsi_assignment/100;
1386:

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

1433: IF l_debug THEN
1434: pqp_utilities.debug(' l_work_pattern is '|| l_work_pattern , 190);
1435: END IF;
1436:
1437: l_working_work_pattern_days := pay_nl_si_pkg.Get_Working_Work_Pattern_days(p_assignment_id) ;
1438: l_total_work_pattern_days := pay_nl_si_pkg.Get_Total_Work_Pattern_days(p_assignment_id) ;
1439:
1440: IF l_debug THEN
1441: pqp_utilities.debug(' l_working_work_pattern_days is '|| l_working_work_pattern_days , 200);

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

1434: pqp_utilities.debug(' l_work_pattern is '|| l_work_pattern , 190);
1435: END IF;
1436:
1437: l_working_work_pattern_days := pay_nl_si_pkg.Get_Working_Work_Pattern_days(p_assignment_id) ;
1438: l_total_work_pattern_days := pay_nl_si_pkg.Get_Total_Work_Pattern_days(p_assignment_id) ;
1439:
1440: IF l_debug THEN
1441: pqp_utilities.debug(' l_working_work_pattern_days is '|| l_working_work_pattern_days , 200);
1442: pqp_utilities.debug(' l_total_work_pattern_days is '|| l_total_work_pattern_days , 210);

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

1496: pqp_utilities.debug(' l_average_ws_si_days is '|| l_average_ws_si_days , 225);
1497: END IF;
1498:
1499: -- get non si days
1500: l_non_si_days := pay_nl_si_pkg.Get_Non_SI_Days(p_assignment_id,l_pay_start_dt,l_pay_end_dt);
1501:
1502: IF l_debug THEN
1503: pqp_utilities.debug(' l_non_si_days is '|| l_non_si_days , 230);
1504: END IF;

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

1667: pqp_utilities.debug(' l_working_work_pattern_days is '|| l_working_work_pattern_days , 50);
1668: END IF;
1669:
1670: IF (l_max_si_method = 0 ) THEN -- 1 indicates 'Payroll Period' 0 indicates Weeks worked.
1671: l_max_si_days := pay_nl_si_pkg.Get_Max_SI_Days(p_assignment_id,l_pay_start_dt,l_pay_end_dt);
1672: ELSE
1673: l_max_si_days := pay_nl_si_pkg.Get_Week_Days(l_pay_start_dt,l_pay_end_dt);
1674: END IF;
1675:

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

1669:
1670: IF (l_max_si_method = 0 ) THEN -- 1 indicates 'Payroll Period' 0 indicates Weeks worked.
1671: l_max_si_days := pay_nl_si_pkg.Get_Max_SI_Days(p_assignment_id,l_pay_start_dt,l_pay_end_dt);
1672: ELSE
1673: l_max_si_days := pay_nl_si_pkg.Get_Week_Days(l_pay_start_dt,l_pay_end_dt);
1674: END IF;
1675:
1676: IF l_debug THEN
1677: pqp_utilities.debug(' l_max_si_days is '|| l_max_si_days , 60);

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

1676: IF l_debug THEN
1677: pqp_utilities.debug(' l_max_si_days is '|| l_max_si_days , 60);
1678: END IF;
1679:
1680: l_non_si_days := pay_nl_si_pkg.Get_Non_SI_Days(p_assignment_id,l_pay_start_dt,l_pay_end_dt);
1681:
1682: IF l_debug THEN
1683: pqp_utilities.debug(' l_non_si_days is '|| l_non_si_days , 70);
1684: END IF;

Line 3718: l_fte := pay_nl_si_pkg.get_part_time_perc( l_assignment_id

3714: -- Call function to check if the user has overridden the part
3715: -- time percentage . If a value is found , use this to derive the
3716: -- FTE
3717: --
3718: l_fte := pay_nl_si_pkg.get_part_time_perc( l_assignment_id
3719: ,p_date_earned
3720: ,p_business_group_id
3721: ,p_assignment_action_id);
3722:

Line 3746: l_fte := pay_nl_si_pkg.get_part_time_perc( p_assignment_id

3742: -- Call function to check if the user has overridden the part
3743: -- time percentage . If a value is found , use this to derive the
3744: -- FTE
3745: --
3746: l_fte := pay_nl_si_pkg.get_part_time_perc( p_assignment_id
3747: ,p_date_earned
3748: ,p_business_group_id
3749: ,p_assignment_action_id);
3750: