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 1031: from per_time_periods

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

Line 1156: from per_time_periods

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

Line 1219: from per_time_periods

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

Line 1227: from per_time_periods

1223: order by start_date ;
1224:
1225: Cursor c_get_db_next_pay_period_dtls is
1226: select start_date,end_date,regular_payment_date
1227: from per_time_periods
1228: where payroll_id = l_payroll_id
1229: and start_date >= trunc(p_effective_date)
1230: order by start_date ;
1231:

Line 1781: from per_time_periods

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

Line 1890: from per_time_periods

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

Line 2000: from per_time_periods

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