DBA Data[Home] [Help]

APPS.AR_CUMULATIVE_BALANCE_REPORT dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 232: FROM fnd_segment_attribute_values

228: l_gl_account_segment varchar2(50);
229:
230: CURSOR segment IS
231: SELECT application_column_name
232: FROM fnd_segment_attribute_values
233: WHERE attribute_value = 'Y'
234: AND segment_attribute_type = 'GL_ACCOUNT'
235: AND id_flex_num in
236: (SELECT chart_of_accounts_id

Line 1104: l_segment_name fnd_segment_attribute_values.application_column_name%TYPE;

1100: p_gl_account_high IN VARCHAR2) IS
1101:
1102:
1103: l_user_id fnd_user.user_id%TYPE;
1104: l_segment_name fnd_segment_attribute_values.application_column_name%TYPE;
1105: l_sql_stmt VARCHAR2(4000);
1106: l_delete_stmt VARCHAR2(200);
1107: l_account_where VARCHAR2(200);
1108: l_co_seg_where VARCHAR2(200);

Line 1247: l_segment_name fnd_segment_attribute_values.application_column_name%TYPE;

1243: p_gl_account_high IN VARCHAR2,
1244: p_refresh_tables IN VARCHAR2 DEFAULT 'N') IS
1245:
1246: l_user_id fnd_user.user_id%TYPE;
1247: l_segment_name fnd_segment_attribute_values.application_column_name%TYPE;
1248: l_sql_stmt VARCHAR2(4000);
1249: /* Variable length increased from 200 to 500 for bug:5181586*/
1250: l_delete_stmt VARCHAR2(500);
1251: /* Change for bug:5181586 ends*/