APPS.PAY_ZA_UIF_ARCHIVE_PKG dependencies on PER_TIME_PERIODS

Line 1058: from per_time_periods ptp

1054: -- Added for Bug 4134166
1055: l_pay_periods_per_year number :=0;
1056: cursor csr_pay_periods_per_year(p_eff_date date, p_payroll_id number) is
1057: select count(ptp.end_date)
1058: from per_time_periods ptp
1059: where ptp.payroll_id = p_payroll_id
1060: and ptp.end_date >= '01-MAR-'||to_char(p_eff_date,'YYYY')
1061: and ptp.end_date < '01-MAR-'||to_number(to_char(p_eff_date,'YYYY')+1);
1062:

Line 1067: from per_time_periods ptp

1063: --Added for Bug 4134166
1064: l_pay_periods_per_month number :=0;
1065: cursor csr_pay_periods_per_month(p_eff_date date, p_payroll_id number)is
1066: select count(ptp.end_date)
1067: from per_time_periods ptp
1068: where ptp.payroll_id = p_payroll_id
1069: and to_char(ptp.end_date,'MMYYYY')= to_char(p_eff_date, 'MMYYYY');
1070:
1071: --UIF Limit