APPS.JA_CN_SI_BANK_DET_PKG dependencies on FND_FLEX_VALUE_CHILDREN_V

Line 406: from FND_FLEX_VALUE_CHILDREN_V ffh

402: l_bsv_temp VARCHAR2(100) :=pv_bsv;
403:
404: CURSOR CUR_PARENT(c_valueset_id pls_integer, c_bsv varchar2) IS
405: select ffh.flex_value_set_id, ffh.FLEX_VALUE, SUMMARY_FLAG
406: from FND_FLEX_VALUE_CHILDREN_V ffh
407: where ffh.flex_value_set_id = c_valueset_id
408: and ffh.PARENT_FLEX_VALUE = c_bsv
409: order by ffh.FLEX_VALUE;
410: l_parent CUR_PARENT%ROWTYPE;

Line 935: from FND_FLEX_VALUE_CHILDREN_V ffvc

931: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NAME', l_inner.description);
932: --calculate level
933: select count(1)
934: into l_parent_count
935: from FND_FLEX_VALUE_CHILDREN_V ffvc
936: where ffvc.flex_value_set_id = l_valueset_id
937: and ffvc.flex_value = l_inner.flex_value;
938: if l_parent_count > 1 then
939: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_LEVEL', '0');

Line 1106: from FND_FLEX_VALUE_CHILDREN_V ffvc

1102: Ja_Cn_Utility.Add_Child_Node('ACCOUNT_NAME', l_extra.description);
1103: --calculate level
1104: select count(1)
1105: into l_parent_count
1106: from FND_FLEX_VALUE_CHILDREN_V ffvc
1107: where ffvc.flex_value_set_id = l_valueset_id
1108: and ffvc.flex_value = l_extra.flex_value;
1109:
1110: if l_parent_count > 1 then