APPS.PQP_NL_PGGM_FUNCTIONS dependencies on STANDARD

Line 1056: --assignment standard conditions for a given effective date

1052: AND date_start <= p_date_earned;
1053:
1054: --
1055: --Cursor to fetch the part time percentage from the
1056: --assignment standard conditions for a given effective date
1057: --
1058: CURSOR c_pt_cur (c_effective_date IN DATE) IS
1059: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) pt_perc
1060: FROM per_assignments_f asg

Line 1722: --assignment standard conditions for a given effective date

1718: WHERE assignment_id = p_assignment_id
1719: AND effective_end_date >= p_period_start_date;
1720: --
1721: --Cursor to fetch the part time percentage from the
1722: --assignment standard conditions for a given effective date
1723: --
1724: CURSOR c_get_ptp(c_effective_date IN DATE) IS
1725: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'0')) pt_perc
1726: FROM per_assignments_f asg

Line 1815: -- If the part time percentage derived from the standard

1811: -- check if the person is a full timer or part timer
1812: -- if the person is a part timer, then the final part time
1813: -- percentage cannot exceed 100% and it cannot exceed 125%
1814: -- for a full timer
1815: -- If the part time percentage derived from the standard
1816: -- conditions is < 100 then the person is a part time employee
1817: -- if the value is equal to or exceeds 100 then this is a full
1818: -- timer
1819: --

Line 1844: --now derive the ptp from standard conditions on this eff date to check

1840: FETCH c_get_num_periods_per_year INTO l_num_periods;
1841: CLOSE c_get_num_periods_per_year;
1842:
1843:
1844: --now derive the ptp from standard conditions on this eff date to check
1845: -- for part/full timers
1846:
1847: OPEN c_get_ptp(l_eff_date);
1848: FETCH c_get_ptp INTO l_ptp;