DBA Data[Home] [Help]

APPS.PAY_PYAUSGC_XMLP_PKG dependencies on PAY_COST_ALLOCATION_KEYFLEX

Line 125: PAY_COST_ALLOCATION_KEYFLEX

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

Line 127: L_CONCATENATED_SEGMENTS PAY_COST_ALLOCATION_KEYFLEX.CONCATENATED_SEGMENTS%TYPE := NULL;

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