APPS.GHR_FORMULA_FUNCTIONS dependencies on GHR_AGENCY_GENERAL

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

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

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

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

Line 1934: l_agency_check_date := ghr_agency_general.get_agency_check_date(l_person_id

1930: exit;
1931: End Loop;
1932:
1933: --get agency_check_date
1934: l_agency_check_date := ghr_agency_general.get_agency_check_date(l_person_id
1935: ,p_asg_id
1936: ,l_end_date
1937: ,l_payroll_id);
1938:

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

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