APPS.PAY_ZA_UIF_ARCHIVE_PKG dependencies on PER_TIME_PERIODS

Line 1060: from per_time_periods ptp

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

Line 1069: from per_time_periods ptp

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