APPS.GCS_TRANSLATION_PKG dependencies on FEM_LN_ITEMS_ATTR

Line 1336: ' FEM_LN_ITEMS_ATTR li,' || g_nl ||

1332: pl_text :=
1333: 'SELECT nvl(sum(nvl(fb.ytd_debit_balance_e, 0)),0), ' ||
1334: 'nvl(sum(nvl(fb.ytd_credit_balance_e, 0)),0)' || g_nl ||
1335: 'FROM FEM_BALANCES fb,' || g_nl ||
1336: ' FEM_LN_ITEMS_ATTR li,' || g_nl ||
1337: ' FEM_EXT_ACCT_TYPES_ATTR fxata' || g_nl ||
1338: 'WHERE fb.dataset_code = ' || p_hier_dataset_code || g_nl ||
1339: 'AND fb.created_by_object_id = ' || fb_object_id || g_nl ||
1340: 'AND fb.cal_period_id = ' || p_prev_period_id || g_nl ||

Line 1603: ' FROM FEM_LN_ITEMS_ATTR li,' || g_nl ||

1599: 'SET begin_ytd_dr = 0,' || g_nl ||
1600: ' begin_ytd_cr = 0' || g_nl ||
1601: 'WHERE EXISTS' || g_nl ||
1602: '(SELECT 1' || g_nl ||
1603: ' FROM FEM_LN_ITEMS_ATTR li,' || g_nl ||
1604: ' FEM_EXT_ACCT_TYPES_ATTR fxata' || g_nl ||
1605: ' WHERE li.line_item_id = tg.line_item_id' || g_nl ||
1606: ' AND li.attribute_id = ' || g_li_acct_type_attr_id || g_nl ||
1607: ' AND li.version_id = ' || g_li_acct_type_v_id || g_nl ||

Line 1620: FROM FEM_LN_ITEMS_ATTR li,

1616: SET begin_ytd_dr = 0,
1617: begin_ytd_cr = 0
1618: WHERE EXISTS
1619: (SELECT 1
1620: FROM FEM_LN_ITEMS_ATTR li,
1621: FEM_EXT_ACCT_TYPES_ATTR fxata
1622: WHERE li.line_item_id = tg.line_item_id
1623: AND li.attribute_id = g_li_acct_type_attr_id
1624: AND li.version_id = g_li_acct_type_v_id

Line 1745: ' FEM_LN_ITEMS_ATTR li,' || g_nl ||

1741: 'FROM' || g_nl ||
1742: ' (SELECT nvl(sum(nvl(fb.ytd_debit_balance_e, 0)),0) ytd_debit, ' ||
1743: 'nvl(sum(nvl(fb.ytd_credit_balance_e, 0)),0) ytd_credit' || g_nl ||
1744: ' FROM FEM_BALANCES fb,' || g_nl ||
1745: ' FEM_LN_ITEMS_ATTR li,' || g_nl ||
1746: ' FEM_EXT_ACCT_TYPES_ATTR fxata' || g_nl ||
1747: ' WHERE fb.dataset_code = ' || p_hier_dataset_code || g_nl ||
1748: ' AND fb.cal_period_id = ' || p_cal_period_id || g_nl ||
1749: ' AND fb.source_system_code = ' || p_source_system_code || g_nl ||

Line 1824: ' FEM_LN_ITEMS_ATTR lia,' || g_nl ||

1820: ' ) func,' || g_nl ||
1821: ' (SELECT nvl(sum(nvl(el.ytd_debit_balance_e, 0)), 0) ytd_debit, ' ||
1822: 'nvl(sum(nvl(el.ytd_credit_balance_e, 0)), 0) ytd_credit' || g_nl ||
1823: ' FROM GCS_ENTRY_LINES el,' || g_nl ||
1824: ' FEM_LN_ITEMS_ATTR lia,' || g_nl ||
1825: ' FEM_EXT_ACCT_TYPES_ATTR xata' || g_nl ||
1826: ' WHERE el.entry_id = ' || p_entry_id || g_nl ||
1827: ' AND lia.line_item_id = el.line_item_id' || g_nl ||
1828: ' AND lia.attribute_id = ' || g_li_acct_type_attr_id || g_nl ||