121: CURSOR C_COST_CENTRE IS
122: SELECT
123: CONCATENATED_SEGMENTS
124: FROM
125: PAY_COST_ALLOCATION_KEYFLEX
126: WHERE COST_ALLOCATION_KEYFLEX_ID = P_COST_CENTRE;
127: L_CONCATENATED_SEGMENTS PAY_COST_ALLOCATION_KEYFLEX.CONCATENATED_SEGMENTS%TYPE := NULL;
128: BEGIN
129: IF P_COST_CENTRE IS NOT NULL THEN
123: CONCATENATED_SEGMENTS
124: FROM
125: PAY_COST_ALLOCATION_KEYFLEX
126: WHERE COST_ALLOCATION_KEYFLEX_ID = P_COST_CENTRE;
127: L_CONCATENATED_SEGMENTS PAY_COST_ALLOCATION_KEYFLEX.CONCATENATED_SEGMENTS%TYPE := NULL;
128: BEGIN
129: IF P_COST_CENTRE IS NOT NULL THEN
130: OPEN C_COST_CENTRE;
131: FETCH C_COST_CENTRE