[Home] [Help]
APPS.HR_MX_EX_EMPLOYEE_API dependencies on PER_PERIODS_OF_SERVICE
Line 23: l_business_group_id per_periods_of_service.business_group_id%TYPE;
19: )
20: IS
21: -- Declare cursors and local variables
22: l_proc VARCHAR2(72);
23: l_business_group_id per_periods_of_service.business_group_id%TYPE;
24:
25: CURSOR csr_get_bg IS
26: SELECT business_group_id
27: FROM per_periods_of_service
Line 27: FROM per_periods_of_service
23: l_business_group_id per_periods_of_service.business_group_id%TYPE;
24:
25: CURSOR csr_get_bg IS
26: SELECT business_group_id
27: FROM per_periods_of_service
28: WHERE period_of_service_id = p_period_of_service_id;
29: --
30: BEGIN
31: