APPS.GHR_FORMULA_FUNCTIONS dependencies on PER_TIME_PERIODS

Line 830: from per_time_periods

826: l_tsp_status_date date;
827:
828: Cursor c_pay_period is
829: select start_date,end_date
830: from per_time_periods
831: where payroll_id in
832: (select payroll_id
833: from per_assignments_f
834: where assignment_id = p_asg_id

Line 901: from per_time_periods

897: and trunc(p_effective_date) between effective_start_date and effective_end_date;
898:
899: Cursor c_pay_period is
900: select start_date,end_date
901: from per_time_periods
902: where payroll_id in
903: (select payroll_id
904: from per_assignments_f
905: where assignment_id = p_asg_id

Line 1033: from per_time_periods

1029: l_opt_name ben_opt_f.name%type;
1030:
1031: Cursor c_pay_period is
1032: select start_date,end_date
1033: from per_time_periods
1034: where payroll_id in
1035: (select payroll_id
1036: from per_assignments_f
1037: where assignment_id = p_asg_id

Line 1160: from per_time_periods

1156:
1157: -- get end date and check date of last pay period of current year that has pay date in this year.
1158: Cursor c_get_db_last_pay_period_dtls is
1159: select end_date,regular_payment_date
1160: from per_time_periods
1161: where payroll_id = l_payroll_id
1162: and to_char(p_effective_date,'YYYY') = to_char(regular_payment_date,'YYYY')
1163: order by start_date desc;
1164: /*

Line 1223: from per_time_periods

1219: and p_effective_date between effective_start_date and effective_end_date;
1220:
1221: Cursor c_get_db_curr_pay_period_dtls is
1222: select start_date,end_date,regular_payment_date
1223: from per_time_periods
1224: where payroll_id = l_payroll_id
1225: and p_effective_date between start_date and end_date
1226: --and end_date = trunc(p_effective_date)
1227: order by start_date ;

Line 1231: from per_time_periods

1227: order by start_date ;
1228:
1229: Cursor c_get_db_next_pay_period_dtls is
1230: select start_date,end_date,regular_payment_date
1231: from per_time_periods
1232: where payroll_id = l_payroll_id
1233: and start_date >= trunc(p_effective_date)
1234: order by start_date ;
1235:

Line 1785: from per_time_periods

1781:
1782: -- get coverage and rate start date
1783: Cursor c_get_dates is
1784: select start_date
1785: from per_time_periods
1786: where payroll_id = v_payroll_id
1787: and start_date >= trunc(p_effective_date)
1788: order by start_date ;
1789:

Line 1894: from per_time_periods

1890:
1891: -- get check__date maianitained in system for the rate start date
1892: Cursor c_get_db_check_date is
1893: select regular_payment_date,end_date
1894: from per_time_periods
1895: where payroll_id = l_payroll_id
1896: and start_date >= trunc(l_rt_strt_dt)
1897: order by start_date ;
1898: Begin

Line 2004: from per_time_periods

2000: and p_effective_date between effective_start_date and effective_end_date;
2001:
2002: Cursor c_get_db_curr_pay_period_dtls is
2003: select start_date,end_date,regular_payment_date
2004: from per_time_periods
2005: where payroll_id = l_payroll_id
2006: and start_date = trunc(p_payroll_period_start_date)
2007: order by start_date ;
2008:

Line 2300: from per_time_periods

2296:
2297: -- pay period start date
2298: Cursor c_get_pay_dates(p_effective_date in date) is
2299: select start_date
2300: from per_time_periods
2301: where payroll_id = v_payroll_id
2302: and p_effective_date between start_date and end_date;
2303:
2304: -- next pay period start date

Line 2307: from per_time_periods

2303:
2304: -- next pay period start date
2305: Cursor c_get_next_pay_period(p_effective_date in date) is
2306: select start_date
2307: from per_time_periods
2308: where payroll_id = v_payroll_id
2309: and start_date >= trunc(p_effective_date)
2310: order by start_date;
2311: