86: RETURN L_PAYROLL;
87: END CF_PAYROLLFORMULA;
88:
89: FUNCTION CF_COST_CENTREFORMULA RETURN VARCHAR2 IS
90: L_COST_CENTRE PAY_COST_ALLOCATION_KEYFLEX.CONCATENATED_SEGMENTS%TYPE;
91: CURSOR C_COST_CENTRE IS
92: SELECT
93: CONCATENATED_SEGMENTS
94: FROM
91: CURSOR C_COST_CENTRE IS
92: SELECT
93: CONCATENATED_SEGMENTS
94: FROM
95: PAY_COST_ALLOCATION_KEYFLEX
96: WHERE COST_ALLOCATION_KEYFLEX_ID = P_COST_ALLOCATION_KEYFLEX_ID;
97: BEGIN
98: OPEN C_COST_CENTRE;
99: FETCH C_COST_CENTRE