APPS.OKL_ACCOUNT_GENERATOR_PVT dependencies on OKL_AG_SOURCE_MAPS

Line 120: l_primary_key_col OKL_AG_SOURCE_MAPS.PRIMARY_KEY_COLUMN%TYPE;

116: )
117: RETURN VARCHAR2
118: AS
119: l_select_string VARCHAR2(4000);
120: l_primary_key_col OKL_AG_SOURCE_MAPS.PRIMARY_KEY_COLUMN%TYPE;
121: l_column_name OKL_AG_SOURCE_MAPS.SELECT_COLUMN%TYPE;
122: l_source_ccid NUMBER;
123: l_segment_value VARCHAR2(50) := NULL;
124: l_select_clause VARCHAR2(1000) := ' SELECT ';

Line 121: l_column_name OKL_AG_SOURCE_MAPS.SELECT_COLUMN%TYPE;

117: RETURN VARCHAR2
118: AS
119: l_select_string VARCHAR2(4000);
120: l_primary_key_col OKL_AG_SOURCE_MAPS.PRIMARY_KEY_COLUMN%TYPE;
121: l_column_name OKL_AG_SOURCE_MAPS.SELECT_COLUMN%TYPE;
122: l_source_ccid NUMBER;
123: l_segment_value VARCHAR2(50) := NULL;
124: l_select_clause VARCHAR2(1000) := ' SELECT ';
125: l_from_clause VARCHAR2(1000) := ' FROM ';

Line 141: FROM OKL_AG_SOURCE_MAPS

137: -- Cursor which selects the source mapping values
138:
139: CURSOR pk_cur IS
140: SELECT select_column
141: FROM OKL_AG_SOURCE_MAPS
142: WHERE ae_line_type = p_ae_line_type
143: AND source = p_source_table;
144:
145: pk_rec pk_cur%ROWTYPE;