819: Where Ussgl_Account = SUBSTR(Parent_Flex_Value,1,6))
820: AND parent_flex_value IN
821: (
822: SELECT flex_value
823: FROM fnd_flex_values
824: WHERE flex_value_set_id = gbl_acc_value_set_id
825: AND enabled_flag = 'Y'
826: );
827:
1627: log(l_module_name, 'Begin');
1628:
1629: SELECT SUBSTR(compiled_value_attributes, 5, 1)
1630: INTO l_account_type
1631: FROM fnd_flex_values
1632: WHERE flex_value = p_account_number
1633: AND flex_value_set_id = gbl_acc_value_set_id;
1634:
1635: log(l_module_name, 'End');
2737: WHERE flex_value_set_id = gbl_acc_value_set_id
2738: AND SUBSTR(parent_flex_value,1,6) = vg_sgl_acct_number;
2739: --AND parent_flex_value = vg_sgl_acct_number;
2740:
2741: CURSOR fnd_flex_values_cur IS
2742: SELECT flex_value
2743: FROM fnd_flex_values
2744: WHERE flex_value_set_id = gbl_acc_value_set_id
2745: AND flex_value BETWEEN vl_child_flex_value_low AND vl_child_flex_value_high
2739: --AND parent_flex_value = vg_sgl_acct_number;
2740:
2741: CURSOR fnd_flex_values_cur IS
2742: SELECT flex_value
2743: FROM fnd_flex_values
2744: WHERE flex_value_set_id = gbl_acc_value_set_id
2745: AND flex_value BETWEEN vl_child_flex_value_low AND vl_child_flex_value_high
2746: ORDER BY 1;
2747:
2835: WHERE ussgl_account = SUBSTR(parent_flex_value,1,6))
2836: AND parent_flex_value IN
2837: (
2838: SELECT flex_value
2839: FROM fnd_flex_values
2840: WHERE flex_value_set_id = gbl_acc_value_set_id
2841: AND enabled_flag = 'Y'
2842: );
2843:
2877:
2878: log(l_module_name, 'vl_child_flex_value_low: '||vl_child_flex_value_low);
2879: log(l_module_name, 'vl_child_flex_value_high: '||vl_child_flex_value_high);
2880:
2881: FOR fnd_flex_values_rec IN fnd_flex_values_cur
2882: LOOP
2883: log(l_module_name, 'fnd_flex_values_rec LOOP Begins...... ');
2884: vg_acct_number := fnd_flex_values_rec.flex_value;
2885: log(l_module_name, 'vg_acct_number: '||vg_acct_number);
2879: log(l_module_name, 'vl_child_flex_value_high: '||vl_child_flex_value_high);
2880:
2881: FOR fnd_flex_values_rec IN fnd_flex_values_cur
2882: LOOP
2883: log(l_module_name, 'fnd_flex_values_rec LOOP Begins...... ');
2884: vg_acct_number := fnd_flex_values_rec.flex_value;
2885: log(l_module_name, 'vg_acct_number: '||vg_acct_number);
2886:
2887: POPULATE_FV_GTAS_FED_ACCOUNTS;
2880:
2881: FOR fnd_flex_values_rec IN fnd_flex_values_cur
2882: LOOP
2883: log(l_module_name, 'fnd_flex_values_rec LOOP Begins...... ');
2884: vg_acct_number := fnd_flex_values_rec.flex_value;
2885: log(l_module_name, 'vg_acct_number: '||vg_acct_number);
2886:
2887: POPULATE_FV_GTAS_FED_ACCOUNTS;
2888:
2893: gbl_error_buf);
2894: RETURN;
2895: END IF;
2896:
2897: log(l_module_name, 'END of fnd_flex_values_rec Loop');
2898: END LOOP; -- fnd_flex_values_cur
2899: log(l_module_name, 'END of fnd_flex_value_hierarchies_cur Loop');
2900: END LOOP; -- fnd_flex_value_hierarchies_cur
2901: END; -- Exception
2894: RETURN;
2895: END IF;
2896:
2897: log(l_module_name, 'END of fnd_flex_values_rec Loop');
2898: END LOOP; -- fnd_flex_values_cur
2899: log(l_module_name, 'END of fnd_flex_value_hierarchies_cur Loop');
2900: END LOOP; -- fnd_flex_value_hierarchies_cur
2901: END; -- Exception
2902: log(l_module_name, 'END of gtas_attributes_cur Loop');
2988: WHERE ussgl_account = SUBSTR(parent_flex_value,1,6))
2989: AND parent_flex_value IN
2990: (
2991: SELECT flex_value
2992: FROM fnd_flex_values
2993: WHERE flex_value_set_id = gbl_acc_value_set_id
2994: AND enabled_flag = 'Y'
2995: );
2996:
3164:
3165: -- Get Account Type
3166: SELECT substr(compiled_value_attributes, 5, 1)
3167: INTO l_acct_type
3168: FROM fnd_flex_values
3169: WHERE flex_value_set_id = gbl_acc_value_set_id
3170: AND flex_value = p_acct_num ;
3171:
3172: log(l_module_name, 'l_acct_type: '||l_acct_type);