DBA Data[Home] [Help]

APPS.GHR_FORMULA_FUNCTIONS dependencies on GHR_AGENCY_GENERAL

Line 1259: l_agency_last_check_date := ghr_agency_general.get_agency_last_check_date(l_person_id,

1255: End loop;
1256: hr_utility.set_location(l_proc_name,30);
1257:
1258: -- Get agency last check date of year
1259: l_agency_last_check_date := ghr_agency_general.get_agency_last_check_date(l_person_id,
1260: p_asg_id,
1261: p_effective_date,
1262: l_payroll_id);
1263: l_last_check_date := nvl(l_agency_last_check_date,l_db_last_check_date);

Line 1274: l_agency_current_check_date := ghr_agency_general.get_agency_check_date(l_person_id,

1270: exit;
1271: End Loop;
1272:
1273: -- get agency check date for current pay period
1274: l_agency_current_check_date := ghr_agency_general.get_agency_check_date(l_person_id,
1275: p_asg_id,
1276: l_db_current_pay_end_date,
1277: l_payroll_id);
1278: l_current_check_date := nvl(l_agency_current_check_date,l_db_current_check_date);

Line 1938: l_agency_check_date := ghr_agency_general.get_agency_check_date(l_person_id

1934: exit;
1935: End Loop;
1936:
1937: --get agency_check_date
1938: l_agency_check_date := ghr_agency_general.get_agency_check_date(l_person_id
1939: ,p_asg_id
1940: ,l_end_date
1941: ,l_payroll_id);
1942:

Line 2035: l_agency_current_check_date := ghr_agency_general.get_agency_check_date(p_person_id,

2031: End Loop;
2032: hr_utility.set_location(l_proc_name,30);
2033:
2034: -- get agency check date for current pay period
2035: l_agency_current_check_date := ghr_agency_general.get_agency_check_date(p_person_id,
2036: p_asg_id,
2037: l_db_current_pay_end_date,
2038: l_payroll_id);
2039: l_current_check_date := nvl(l_agency_current_check_date,l_db_current_check_date);