APPS.PQP_NL_PGGM_FUNCTIONS dependencies on STANDARD

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

1206: AND date_start <= p_date_earned;
1207:
1208: --
1209: --Cursor to fetch the part time percentage from the
1210: --assignment standard conditions for a given effective date
1211: --
1212: CURSOR c_pt_cur (c_effective_date IN DATE) IS
1213: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'100')) pt_perc
1214: FROM per_assignments_f asg

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

1872: WHERE assignment_id = p_assignment_id
1873: AND effective_end_date >= p_period_start_date;
1874: --
1875: --Cursor to fetch the part time percentage from the
1876: --assignment standard conditions for a given effective date
1877: --
1878: CURSOR c_get_ptp(c_effective_date IN DATE) IS
1879: SELECT fnd_number.canonical_to_number(NVL(target.SEGMENT29,'0')) pt_perc
1880: FROM per_assignments_f asg

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

1965: -- check if the person is a full timer or part timer
1966: -- if the person is a part timer, then the final part time
1967: -- percentage cannot exceed 100% and it cannot exceed 125%
1968: -- for a full timer
1969: -- If the part time percentage derived from the standard
1970: -- conditions is < 100 then the person is a part time employee
1971: -- if the value is equal to or exceeds 100 then this is a full
1972: -- timer
1973: --

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

1994: FETCH c_get_num_periods_per_year INTO l_num_periods;
1995: CLOSE c_get_num_periods_per_year;
1996:
1997:
1998: --now derive the ptp from standard conditions on this eff date to check
1999: -- for part/full timers
2000:
2001: OPEN c_get_ptp(l_eff_date);
2002: FETCH c_get_ptp INTO l_ptp;