DBA Data[Home] [Help]

APPS.FEM_INTG_BAL_ENG_LOAD_PKG dependencies on FEM_NAT_ACCTS_ATTR

Line 1454: FROM FEM_NAT_ACCTS_ATTR naa_fe,

1450: UPDATE FEM_BAL_POST_INTERIM_GT bpi
1451: SET (FINANCIAL_ELEM_ID, LINE_ITEM_ID) =
1452: (SELECT nvl(naa_fe.dim_attribute_numeric_member, bpi.financial_elem_id),
1453: nvl(naa_li.dim_attribute_numeric_member, bpi.line_item_id)
1454: FROM FEM_NAT_ACCTS_ATTR naa_fe,
1455: FEM_NAT_ACCTS_ATTR naa_li
1456: WHERE naa_fe.attribute_id (+)= v_na_fe_attr_id
1457: AND naa_fe.version_id (+)= v_na_fe_v_id
1458: AND naa_fe.natural_account_id (+)= bpi.natural_account_id

Line 1455: FEM_NAT_ACCTS_ATTR naa_li

1451: SET (FINANCIAL_ELEM_ID, LINE_ITEM_ID) =
1452: (SELECT nvl(naa_fe.dim_attribute_numeric_member, bpi.financial_elem_id),
1453: nvl(naa_li.dim_attribute_numeric_member, bpi.line_item_id)
1454: FROM FEM_NAT_ACCTS_ATTR naa_fe,
1455: FEM_NAT_ACCTS_ATTR naa_li
1456: WHERE naa_fe.attribute_id (+)= v_na_fe_attr_id
1457: AND naa_fe.version_id (+)= v_na_fe_v_id
1458: AND naa_fe.natural_account_id (+)= bpi.natural_account_id
1459: AND naa_li.attribute_id (+)= v_na_li_attr_id