[Home] [Help]
137: annual_to_period
138: 21-Jun-04 bmanyam 115.62 Bug# 3704632 - Added NVL() to p_end_date parameter
139: in the cursot to find number_of_periods in function get_periods_between().
140: 22-Jun-04 bmanyam 115.63 Bug# 3704632 - Removed the above change. Added
141: select clause to fetch end-date of pay-year from per_time_periods
142: for 'Calender Month' and 'Lunar Month'
143: 29-Nov-04 kmahendr 115.64 Codes added for new Rate Start date
144: 03-Dec-04 vvprabhu 115.65 Bug 3980063 SSBEN Trace Enhancement
145: 21-Dec-04 kmahendr 115.66 Bug#4037102 - nvl used to pass start date
408: v_start_date in date,
409: v_end_date in date) is
410: select ptp.start_date,
411: ptp.end_date
412: from per_time_periods ptp
413: where ptp.payroll_id = v_payroll_id
414: and ptp.end_date between
415: v_start_date and v_end_date;
416: --
444: select sum(
445: ben_distribute_rates.decde_bits(
446: bitand(power(2,count(end_date )) -1,p_frq_bitmap_no)
447: ))
448: from per_time_periods
449: where payroll_id = p_payroll_id
450: and --end_date -- Bug 6830210
451: regular_payment_date -- Bug 6830210
452: between p_rt_start
457: cursor c_count_periods(v_payroll_id in number,
458: v_start_date in date,
459: v_end_date in date) is
460: select count(1)
461: from per_time_periods ptp
462: where ptp.payroll_id = v_payroll_id
463: -- and nvl(ptp.regular_payment_date,ptp.end_date) between
464: and ptp.end_date between
465: v_start_date and v_end_date;
587: -- 3704632 : Added IF-CLAUSE here.
588: if (p_end_date is null) THEN
589: select MAX(end_date)
590: into l_max_end_date
591: from per_time_periods
592: where payroll_id = p_payroll_id
593: and TO_CHAR(end_date,'YYYY') =
594: (SELECT TO_CHAR(end_date,'YYYY')
595: from per_time_periods
591: from per_time_periods
592: where payroll_id = p_payroll_id
593: and TO_CHAR(end_date,'YYYY') =
594: (SELECT TO_CHAR(end_date,'YYYY')
595: from per_time_periods
596: where payroll_id = p_payroll_id
597: and p_start_date between start_date and end_date
598: );
599: END IF;
600: -- 3704632 : End changes
601:
602: select count(*)
603: into l_periods
604: from per_time_periods
605: where payroll_id = p_payroll_id
606: and end_date between p_start_date and NVL(p_end_date,l_max_end_date); -- 3704632 : Added NVL() here.
607:
608: else
1047: v_start_date in date,
1048: v_end_date in date) is
1049: select ptp.start_date,
1050: ptp.end_date
1051: from per_time_periods ptp
1052: where ptp.payroll_id = v_payroll_id
1053: and ptp.end_date between
1054: v_start_date and v_end_date;
1055: --
1085: select sum(
1086: ben_distribute_rates.decde_bits(
1087: bitand(power(2,count(end_date )) -1,p_frq_bitmap_no)
1088: ))
1089: from per_time_periods
1090: where payroll_id = p_payroll_id
1091: and --end_date -- Bug 6830210
1092: regular_payment_date -- Bug 6830210
1093: between p_rt_start
1098: cursor c_count_periods(v_payroll_id in number,
1099: v_start_date in date,
1100: v_end_date in date) is
1101: select count(1)
1102: from per_time_periods ptp
1103: where ptp.payroll_id = v_payroll_id
1104: -- and nvl(ptp.regular_payment_date,ptp.end_date) between
1105: and ptp.end_date between
1106: v_start_date and v_end_date;
1113: cursor c_count_periods_chq(v_payroll_id in number,
1114: v_start_date in date,
1115: v_end_date in date) is
1116: select count(1)
1117: from per_time_periods ptp
1118: where ptp.payroll_id = v_payroll_id
1119: -- and ptp.end_date between
1120: -- v_start_date and v_end_date
1121: -- Bug 6455096
1252: else
1253: --
1254: select count(*)
1255: into l_periods
1256: from per_time_periods
1257: where payroll_id = p_payroll_id
1258: and end_date
1259: between p_start_date
1260: and p_end_date;
2211: cursor c_parse_periods(v_payroll_id in number,
2212: v_start_date in date,
2213: v_end_date in date ) is
2214: select min(ptp.start_date)
2215: from per_time_periods ptp
2216: where ptp.payroll_id = v_payroll_id
2217: and ptp.start_date between
2218: v_start_date and v_end_date;
2219: --