APPS.FV_REIMB_ACTIVITY_PROCESS dependencies on FND_FLEX_VALUES

Line 22: g_reimb_flex_value_id fnd_flex_values.flex_value_id%TYPE;

18: g_ussgl_flex_value_set_id NUMBER;
19: g_apps_id Fnd_Id_Flex_Structures.application_id%TYPE;
20: g_id_flex_code Fnd_Id_Flex_Structures.id_flex_code%TYPE;
21: g_delimiter Fnd_Id_Flex_Structures.concatenated_segment_delimiter%TYPE;
22: g_reimb_flex_value_id fnd_flex_values.flex_value_id%TYPE;
23:
24: -- Variables used for dynamic sql
25:
26: g_where VARCHAR2(2000);

Line 1480: FROM fnd_flex_values_vl f

1476: log(C_STATE_LEVEL, l_module, ' l_low_reimb: ' ||l_low_reimb);
1477: log(C_STATE_LEVEL, l_module, ' l_high_reimb ' ||l_high_reimb);
1478:
1479: g_agree_sql:='SELECT f.flex_value
1480: FROM fnd_flex_values_vl f
1481: where flex_value_set_id = :g_flex_reimb_value_id
1482: AND flex_value BETWEEN '||''''||l_low_reimb||''''||' AND '||''''||l_high_reimb||''''||'
1483: AND f.flex_value in (SELECT r.trx_number
1484: FROM ra_customer_trx_all r,

Line 1495: FROM fnd_flex_values_vl f

1491: log(C_STATE_LEVEL, l_module, 'User has given reimbursable agreement range as parameters for this process. ');
1492: ELSE
1493:
1494: g_agree_sql:= 'SELECT f.flex_value
1495: FROM fnd_flex_values_vl f
1496: where flex_value_set_id = :g_flex_reimb_value_id
1497: AND f.flex_value in(SELECT r.trx_number
1498: FROM ra_customer_trx_all r,
1499: ra_cust_trx_types_all t