APPS.HR_SA_PERIODS_OF_SERVICE_API dependencies on PER_PERIODS_OF_SERVICE

Line 51: l_business_group_id per_periods_of_service.business_group_id%TYPE;

47: ) is
48: --
49: -- Declare cursors and local variables
50: --
51: l_business_group_id per_periods_of_service.business_group_id%TYPE;
52: l_proc varchar2(72) := g_package||'update_sa_pds_details';
53: l_legislation_code varchar2(2);
54: --
55: cursor csr_get_business_group_id is

Line 57: from per_periods_of_service per

53: l_legislation_code varchar2(2);
54: --
55: cursor csr_get_business_group_id is
56: select per.business_group_id
57: from per_periods_of_service per
58: where per.period_of_service_id = p_period_of_service_id;
59: --
60: cursor csr_bg is
61: select legislation_code