APPS.PQP_NL_EXT_FUNCTIONS dependencies on PER_TIME_PERIODS

Line 798: FROM per_time_periods

794: --payroll period, given the max date earned
795: CURSOR c_get_next_start_date(c_date_earned IN DATE
796: ,c_payroll_id IN NUMBER) IS
797: SELECT start_date
798: FROM per_time_periods
799: WHERE payroll_id = c_payroll_id
800: AND start_date > c_date_earned
801: AND rownum = 1;
802:

Line 808: FROM per_time_periods

804: --payroll period, given the asg start date and payroll_id
805: CURSOR c_get_first_start_date(c_start_date IN DATE
806: ,c_payroll_id IN NUMBER) IS
807: SELECT start_date
808: FROM per_time_periods
809: WHERE payroll_id = c_payroll_id
810: AND c_start_date BETWEEN start_date
811: AND end_date;
812:

Line 965: FROM per_time_periods

961: --payroll period, given the max date earned
962: CURSOR c_get_next_start_date(c_date_earned IN DATE
963: ,c_payroll_id IN NUMBER) IS
964: SELECT start_date
965: FROM per_time_periods
966: WHERE payroll_id = c_payroll_id
967: AND start_date > c_date_earned
968: AND rownum = 1;
969:

Line 975: FROM per_time_periods

971: --payroll period, given the asg start date and payroll_id
972: CURSOR c_get_first_start_date(c_start_date IN DATE
973: ,c_payroll_id IN NUMBER) IS
974: SELECT start_date
975: FROM per_time_periods
976: WHERE payroll_id = c_payroll_id
977: AND c_start_date BETWEEN start_date
978: AND end_date;
979: