DBA Data[Home] [Help]

APPS.AR_CUMULATIVE_BALANCE_REPORT dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 258: FROM fnd_segment_attribute_values

254: l_gl_account_segment varchar2(50);
255:
256: CURSOR segment IS
257: SELECT application_column_name
258: FROM fnd_segment_attribute_values
259: WHERE attribute_value = 'Y'
260: AND segment_attribute_type = 'GL_ACCOUNT'
261: AND id_flex_num in
262: (SELECT chart_of_accounts_id

Line 1130: l_segment_name fnd_segment_attribute_values.application_column_name%TYPE;

1126: p_gl_account_high IN VARCHAR2) IS
1127:
1128:
1129: l_user_id fnd_user.user_id%TYPE;
1130: l_segment_name fnd_segment_attribute_values.application_column_name%TYPE;
1131: l_sql_stmt VARCHAR2(4000);
1132: l_delete_stmt VARCHAR2(200);
1133: l_account_where VARCHAR2(200);
1134: l_co_seg_where VARCHAR2(200);

Line 1276: l_segment_name fnd_segment_attribute_values.application_column_name%TYPE;

1272: p_gl_account_high IN VARCHAR2,
1273: p_refresh_tables IN VARCHAR2 DEFAULT 'N') IS
1274:
1275: l_user_id fnd_user.user_id%TYPE;
1276: l_segment_name fnd_segment_attribute_values.application_column_name%TYPE;
1277: l_sql_stmt VARCHAR2(4000);
1278: /* Variable length increased from 200 to 500 for bug:5181586*/
1279: l_delete_stmt VARCHAR2(500);
1280: /* Change for bug:5181586 ends*/