APPS.GHR_PAR_EXTRA_INFO_API dependencies on PER_TIME_PERIODS

Line 934: FROM per_time_periods

930: AND information_type = 'GHR_US_PAR_PAYROLL_TYPE';
931:
932: CURSOR c_start_date(c_payroll_id pay_payrolls_f.payroll_id%type, c_year varchar2, c_month varchar2) IS
933: SELECT min(start_date) start_date
934: FROM per_time_periods
935: WHERE payroll_id = c_payroll_id
936: AND TO_CHAR(start_date,'YYYY') = c_year
937: AND TO_CHAR(start_date,'MM') = c_month;
938:

Line 942: l_start_date per_time_periods.start_date%type;

938:
939:
940: l_retirement_plan ghr_pa_requests.retirement_plan%type;
941: l_pa_request_id ghr_pa_requests.pa_request_id%type;
942: l_start_date per_time_periods.start_date%type;
943: l_effective_date ghr_pa_requests.effective_date%type;
944: l_first_noa_code ghr_pa_requests.first_noa_code%type;
945: l_tenure ghr_pa_requests.tenure%type;
946: l_annuitant_indicator ghr_pa_requests.annuitant_indicator%type;