APPS.PAY_ES_TWR_CALC_PKG dependencies on PER_TIME_PERIODS

Line 710: FROM per_time_periods ptp

706: ,peffective_date IN DATE) RETURN NUMBER IS
707: --
708: CURSOR csr_get_period_num(c_payroll_id NUMBER,c_effective_date DATE) IS
709: SELECT ptp.period_num
710: FROM per_time_periods ptp
711: WHERE ptp.payroll_id = c_payroll_id
712: AND c_effective_date BETWEEN ptp.start_date
713: AND ptp.end_date;
714: --

Line 715: l_no_period per_time_periods.period_num%TYPE;

711: WHERE ptp.payroll_id = c_payroll_id
712: AND c_effective_date BETWEEN ptp.start_date
713: AND ptp.end_date;
714: --
715: l_no_period per_time_periods.period_num%TYPE;
716: --
717: BEGIN
718: --
719: OPEN csr_get_period_num(payroll_id,peffective_date);

Line 756: ,per_time_periods ptp

752: CURSOR csr_payroll_end_date(c_payroll_id NUMBER
753: ,c_effective_date DATE) IS
754: SELECT max(period_num)
755: FROM pay_payrolls_f ppf
756: ,per_time_periods ptp
757: WHERE ppf.payroll_id = c_payroll_id
758: AND ppf.period_type = ptp.period_type
759: AND ppf.payroll_id = ptp.payroll_id
760: AND c_effective_date BETWEEN effective_start_date AND effective_end_date;