APPS.GCS_TRANS_RE_DYNAMIC_PKG dependencies on FEM_LN_ITEMS_ATTR

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

447: ' AND fb_in.currency_code = ''' || p_from_ccy || '''' || g_nl ||
448: ' AND fb_in.ledger_id = ' || p_ledger_id || g_nl ||
449: ' AND fb_in.entity_id = ' || p_entity_id || g_nl ||
450: ' GROUP BY ' || g_nl ||' fb_in.line_item_id) fb,' || g_nl ||
451: ' FEM_LN_ITEMS_ATTR li,' || g_nl ||
452: ' FEM_EXT_ACCT_TYPES_ATTR fxata,' || g_nl ||
453: ' GCS_HISTORICAL_RATES ghr' || g_nl ||
454: 'WHERE li.line_item_id = fb.line_item_id' || g_nl ||
455: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||

Line 536: FEM_LN_ITEMS_ATTR li,

532: AND fb_in.currency_code = p_from_ccy
533: AND fb_in.ledger_id = p_ledger_id
534: AND fb_in.entity_id = p_entity_id
535: GROUP BY fb_in.line_item_id) fb,
536: FEM_LN_ITEMS_ATTR li,
537: FEM_EXT_ACCT_TYPES_ATTR fxata,
538: GCS_HISTORICAL_RATES ghr
539: WHERE li.line_item_id = fb.line_item_id
540: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id

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

617: ' AND fb_in.source_system_code = ' || p_source_system_code || g_nl ||
618: ' AND fb_in.currency_code = ''' || p_from_ccy || '''' || g_nl ||
619: ' AND fb_in.ledger_id = ' || p_ledger_id || g_nl ||
620: ' AND fb_in.entity_id = ' || p_entity_id || ') fb,' || g_nl ||
621: ' FEM_LN_ITEMS_ATTR li,' || g_nl ||
622: ' FEM_EXT_ACCT_TYPES_ATTR fxata,' || g_nl ||
623: ' GCS_HISTORICAL_RATES ghr' || g_nl ||
624: 'WHERE li.line_item_id = fb.line_item_id' || g_nl ||
625: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||

Line 705: FEM_LN_ITEMS_ATTR li,

701: AND fb_in.source_system_code = p_source_system_code
702: AND fb_in.currency_code = p_from_ccy
703: AND fb_in.ledger_id = p_ledger_id
704: AND fb_in.entity_id = p_entity_id) fb,
705: FEM_LN_ITEMS_ATTR li,
706: FEM_EXT_ACCT_TYPES_ATTR fxata,
707: GCS_HISTORICAL_RATES ghr
708: WHERE li.line_item_id = fb.line_item_id
709: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id

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

872: ' AND fb_in.entity_id = ' || p_entity_id || g_nl ||
873: ' GROUP BY ' || g_nl ||' fb_in.line_item_id) fb,' || g_nl ||
874: ' FEM_BALANCES fbp,' || g_nl ||
875: ' GCS_HISTORICAL_RATES ghr,' || g_nl ||
876: ' FEM_LN_ITEMS_ATTR li,' || g_nl ||
877: ' FEM_EXT_ACCT_TYPES_ATTR fxata' || g_nl ||
878: 'WHERE fbp.created_by_object_id (+)= ' || fb_object_id || g_nl ||
879: 'AND li.line_item_id = fb.line_item_id' || g_nl ||
880: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||

Line 974: FEM_LN_ITEMS_ATTR li,

970: AND fb_in.entity_id = p_entity_id
971: GROUP BY fb_in.line_item_id) fb,
972: FEM_BALANCES fbp,
973: GCS_HISTORICAL_RATES ghr,
974: FEM_LN_ITEMS_ATTR li,
975: FEM_EXT_ACCT_TYPES_ATTR fxata
976: WHERE fbp.created_by_object_id (+)= fb_object_id
977: AND li.line_item_id = fb.line_item_id
978: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id

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

1070: ' AND fb_in.ledger_id = ' || p_ledger_id || g_nl ||
1071: ' AND fb_in.entity_id = ' || p_entity_id || ') fb,' || g_nl ||
1072: ' FEM_BALANCES fbp,' || g_nl ||
1073: ' GCS_HISTORICAL_RATES ghr,' || g_nl ||
1074: ' FEM_LN_ITEMS_ATTR li,' || g_nl ||
1075: ' FEM_EXT_ACCT_TYPES_ATTR fxata' || g_nl ||
1076: 'WHERE fbp.created_by_object_id (+)= ' || fb_object_id || g_nl ||
1077: 'AND li.line_item_id = fb.line_item_id' || g_nl ||
1078: 'AND li.attribute_id = ' || gcs_translation_pkg.g_li_acct_type_attr_id || g_nl ||

Line 1171: FEM_LN_ITEMS_ATTR li,

1167: AND fb_in.ledger_id = p_ledger_id
1168: AND fb_in.entity_id = p_entity_id) fb,
1169: FEM_BALANCES fbp,
1170: GCS_HISTORICAL_RATES ghr,
1171: FEM_LN_ITEMS_ATTR li,
1172: FEM_EXT_ACCT_TYPES_ATTR fxata
1173: WHERE fbp.created_by_object_id (+)= fb_object_id
1174: AND li.line_item_id = fb.line_item_id
1175: AND li.attribute_id = gcs_translation_pkg.g_li_acct_type_attr_id