eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GCS_TRANS_RE_DYN_BUILD_PKG dependencies on GCS_TRANS_DYN_BUILD_PKG

Line 128: GCS_TRANS_DYN_BUILD_PKG.Initialize_Dimensions;

124: raise gcs_ccy_applsys_not_found;
125: END IF;
126:
127: -- Bugfix 5725759: Initialize the variables that determines the required dimensions.
128: GCS_TRANS_DYN_BUILD_PKG.Initialize_Dimensions;
129:
130: -- Create the package body
131: body_block :=
132: 'CREATE OR REPLACE PACKAGE BODY GCS_TRANS_RE_DYNAMIC_PKG AS

Line 271: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(''' AND ghr1.', ' = ghr.', ''' || g_nl ||', line_num, 'F');

267: curr_pos := curr_pos + g_line_size;
268: line_num := line_num + 1;
269: END LOOP;
270:
271: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(''' AND ghr1.', ' = ghr.', ''' || g_nl ||', line_num, 'F');
272:
273: --Bugfix 6111815: Only Roll Forward Rates Where Standard RE Rate Flag is Y
274: body_block :=
275: ''' AND ghr1.cal_period_id = '' || p_prev_period_id || '')'' || g_nl ||

Line 304: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(''' AND ghr3.', ' = ghr2.', ''' || g_nl ||', line_num, 'F');

300: curr_pos := curr_pos + g_line_size;
301: line_num := line_num + 1;
302: END LOOP;
303:
304: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(''' AND ghr3.', ' = ghr2.', ''' || g_nl ||', line_num, 'F');
305:
306: body_block :=
307: ''' AND ghr3.from_currency = ghr2.from_currency'' || g_nl ||
308: '' AND ghr3.to_currency = ghr2.to_currency '' || g_nl ||

Line 347: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr1.', ' = ghr.', '', line_num, 'F');

343: curr_pos := curr_pos + g_line_size;
344: line_num := line_num + 1;
345: END LOOP;
346:
347: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr1.', ' = ghr.', '', line_num, 'F');
348:
349: --Bugfix 6111815: Only Roll Forward Rates Where Standard RE Rate Flag is Y
350: body_block :=
351: ' AND ghr1.cal_period_id = p_prev_period_id)

Line 380: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr3.', ' = ghr2.', '', line_num, 'F');

376: curr_pos := curr_pos + g_line_size;
377: line_num := line_num + 1;
378: END LOOP;
379:
380: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr3.', ' = ghr2.', '', line_num, 'F');
381:
382: body_block :=
383: ' AND ghr3.from_currency = ghr2.from_currency
384: AND ghr3.to_currency = ghr2.to_currency

Line 425: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(''' AND ghr2.', ' (+)= ghr3.', ''' || g_nl ||', line_num, 'F');

421: curr_pos := curr_pos + g_line_size;
422: line_num := line_num + 1;
423: END LOOP;
424:
425: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(''' AND ghr2.', ' (+)= ghr3.', ''' || g_nl ||', line_num, 'F');
426:
427: body_block :=
428: ''' )'');
429:

Line 467: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr2.', ' (+)= ghr3.', '', line_num, 'F');

463: curr_pos := curr_pos + g_line_size;
464: line_num := line_num + 1;
465: END LOOP;
466:
467: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr2.', ' (+)= ghr3.', '', line_num, 'F');
468:
469: --Bugfix 6111815: Only Roll Forward Rates Where Standard RE Rate Flag is Y
470: body_block :=
471: ' );

Line 496: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list('''ghr.', ' '' ||', '''NULL, '' ||', line_num, 'F');

492: curr_pos := curr_pos + g_line_size;
493: line_num := line_num + 1;
494: END LOOP;
495:
496: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list('''ghr.', ' '' ||', '''NULL, '' ||', line_num, 'F');
497:
498: body_block :=
499: '''ghr.translated_rate, ghr.translated_amount, ''''P'''', ''''N'''', '' ||
500: ''ghr.account_type_code, ''''N'''', sysdate, '' ||

Line 530: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list('''AND ghr1.', ' = ghr.', ''' || g_nl ||', line_num, 'F');

526: curr_pos := curr_pos + g_line_size;
527: line_num := line_num + 1;
528: END LOOP;
529:
530: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list('''AND ghr1.', ' = ghr.', ''' || g_nl ||', line_num, 'F');
531:
532: body_block :=
533: ''' AND ghr1.update_flag = ''''N'''''' || g_nl ||
534: '' AND ghr1.from_currency = ghr.from_currency'' || g_nl ||

Line 566: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' ghr.', '', ' NULL,', line_num, 'F');

562: curr_pos := curr_pos + g_line_size;
563: line_num := line_num + 1;
564: END LOOP;
565:
566: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' ghr.', '', ' NULL,', line_num, 'F');
567:
568: --Bugfix 6111815: Only Roll Forward Rates Where Standard RE Rate Flag is Y
569: body_block :=
570: ' ghr.translated_rate, ghr.translated_amount, ''P'', ''N'',

Line 601: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr1.', ' = ghr.', '', line_num, 'F');

597: curr_pos := curr_pos + g_line_size;
598: line_num := line_num + 1;
599: END LOOP;
600:
601: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr1.', ' = ghr.', '', line_num, 'F');
602:
603: body_block :=
604: ' AND ghr1.update_flag = ''N''
605: AND ghr1.from_currency = ghr.from_currency

Line 685: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list('''fb.', ' '' ||', '''NULL, '' ||', line_num, 'F');

681: curr_pos := curr_pos + g_line_size;
682: line_num := line_num + 1;
683: END LOOP;
684:
685: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list('''fb.', ' '' ||', '''NULL, '' ||', line_num, 'F');
686:
687: body_block :=
688: '''0, 0, 0, 0,'' || g_nl ||
689: ''round(nvl(ghr.translated_amount * 0,'' || g_nl ||

Line 741: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(''' fb_in.', ' '' ||', '', line_num, 'F');

737: curr_pos := curr_pos + g_line_size;
738: line_num := line_num + 1;
739: END LOOP;
740:
741: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(''' fb_in.', ' '' ||', '', line_num, 'F');
742:
743: body_block :=
744: ''' SUM(ytd_debit_balance_e) sum_ytd_debit_balance_e,'' || g_nl ||
745: '' SUM(ytd_credit_balance_e) sum_ytd_credit_balance_e'' || g_nl ||

Line 764: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(''' fb_in.', ' '' ||', '', line_num, 'F');

760: curr_pos := curr_pos + g_line_size;
761: line_num := line_num + 1;
762: END LOOP;
763:
764: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(''' fb_in.', ' '' ||', '', line_num, 'F');
765:
766: --Bugfix 6111815: Added Standard RE Rate Flag
767: body_block :=
768: ''' fb_in.line_item_id) fb,'' || g_nl ||

Line 798: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list('''AND ghr.', ' = fb.', ''' || g_nl ||', line_num, 'F');

794: line_num := line_num + 1;
795: END LOOP;
796:
797: --Bugfix 6111815: Remove the outer join
798: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list('''AND ghr.', ' = fb.', ''' || g_nl ||', line_num, 'F');
799:
800: body_block :=
801: ''''');
802:

Line 828: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb.', '', ' NULL,', line_num, 'F');

824: curr_pos := curr_pos + g_line_size;
825: line_num := line_num + 1;
826: END LOOP;
827:
828: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb.', '', ' NULL,', line_num, 'F');
829:
830: body_block :=
831: ' 0, 0, 0, 0,
832: round(nvl(ghr.translated_amount * 0,

Line 884: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb_in.', '', '', line_num, 'F');

880: curr_pos := curr_pos + g_line_size;
881: line_num := line_num + 1;
882: END LOOP;
883:
884: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb_in.', '', '', line_num, 'F');
885:
886: body_block :=
887: ' SUM(ytd_debit_balance_e) sum_ytd_debit_balance_e,
888: SUM(ytd_credit_balance_e) sum_ytd_credit_balance_e

Line 907: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb_in.', '', '', line_num, 'F');

903: curr_pos := curr_pos + g_line_size;
904: line_num := line_num + 1;
905: END LOOP;
906:
907: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb_in.', '', '', line_num, 'F');
908:
909: --Bugfix 6111815: Added Standard RE Rate Flag
910: body_block :=
911: ' fb_in.line_item_id) fb,

Line 941: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr.', ' = fb.', '', line_num, 'F');

937: line_num := line_num + 1;
938: END LOOP;
939:
940: --Bugfix 6111815: Removed Outer Join
941: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr.', ' = fb.', '', line_num, 'F');
942:
943: body_block :=
944: ' ;
945:

Line 972: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list('''fb.', ' '' ||', '''NULL, '' ||', line_num, 'F');

968: curr_pos := curr_pos + g_line_size;
969: line_num := line_num + 1;
970: END LOOP;
971:
972: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list('''fb.', ' '' ||', '''NULL, '' ||', line_num, 'F');
973:
974: body_block :=
975: '''0, 0, 0, 0,'' || g_nl ||
976: ''round(nvl(ghr.translated_amount * 0,'' || g_nl ||

Line 1028: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(''' fb_in.', ' '' ||', '', line_num, 'F');

1024: curr_pos := curr_pos + g_line_size;
1025: line_num := line_num + 1;
1026: END LOOP;
1027:
1028: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(''' fb_in.', ' '' ||', '', line_num, 'F');
1029:
1030: --Bugfix 6111815: Added Standard RE Rate Flag
1031: body_block :=
1032: ''' ytd_debit_balance_e sum_ytd_debit_balance_e,'' || g_nl ||

Line 1070: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list('''AND ghr.', ' = fb.', ''' || g_nl ||', line_num, 'F');

1066: line_num := line_num + 1;
1067: END LOOP;
1068:
1069: --Bugfix 6111815: Removed Outer Join
1070: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list('''AND ghr.', ' = fb.', ''' || g_nl ||', line_num, 'F');
1071:
1072: body_block :=
1073: ''''');
1074:

Line 1100: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb.', '', ' NULL,', line_num, 'F');

1096: curr_pos := curr_pos + g_line_size;
1097: line_num := line_num + 1;
1098: END LOOP;
1099:
1100: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb.', '', ' NULL,', line_num, 'F');
1101:
1102: body_block :=
1103: ' 0, 0, 0, 0,
1104: round(nvl(ghr.translated_amount * 0,

Line 1156: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb_in.', '', '', line_num, 'F');

1152: curr_pos := curr_pos + g_line_size;
1153: line_num := line_num + 1;
1154: END LOOP;
1155:
1156: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb_in.', '', '', line_num, 'F');
1157:
1158: --Bugfix 6111815: Removed Added Standard RE Rate Flag
1159: body_block :=
1160: ' ytd_debit_balance_e sum_ytd_debit_balance_e,

Line 1198: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr.', ' = fb.', '', line_num, 'F');

1194: line_num := line_num + 1;
1195: END LOOP;
1196:
1197: --Bugfix 6111815: Removed Outer Join
1198: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr.', ' = fb.', '', line_num, 'F');
1199:
1200: body_block :=
1201: ' ;
1202: END IF;

Line 1306: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list('''fb.', ' '' ||', '''NULL, '' ||', line_num, 'F');

1302: curr_pos := curr_pos + g_line_size;
1303: line_num := line_num + 1;
1304: END LOOP;
1305:
1306: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list('''fb.', ' '' ||', '''NULL, '' ||', line_num, 'F');
1307:
1308: body_block :=
1309: 'g_nl ||
1310: ''round(nvl(ghr.translated_amount * 0,'' || g_nl ||

Line 1366: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(''' fb_in.', ' '' ||', '', line_num, 'F');

1362: curr_pos := curr_pos + g_line_size;
1363: line_num := line_num + 1;
1364: END LOOP;
1365:
1366: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(''' fb_in.', ' '' ||', '', line_num, 'F');
1367:
1368: body_block :=
1369: ''' SUM(ptd_debit_balance_e) sum_ptd_debit_balance_e,'' || g_nl ||
1370: '' SUM(ptd_credit_balance_e) sum_ptd_credit_balance_e,'' || g_nl ||

Line 1391: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(''' fb_in.', ' '' ||', '', line_num, 'F');

1387: curr_pos := curr_pos + g_line_size;
1388: line_num := line_num + 1;
1389: END LOOP;
1390:
1391: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(''' fb_in.', ' '' ||', '', line_num, 'F');
1392:
1393: body_block :=
1394: ''' fb_in.line_item_id) fb,'' || g_nl ||
1395: '' FEM_BALANCES fbp,'' || g_nl ||

Line 1424: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list('''AND fbp.', ' (+)= fb.', ''' || g_nl ||', line_num, 'F');

1420: curr_pos := curr_pos + g_line_size;
1421: line_num := line_num + 1;
1422: END LOOP;
1423:
1424: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list('''AND fbp.', ' (+)= fb.', ''' || g_nl ||', line_num, 'F');
1425:
1426: --Bugfix 6111815: Added Standard RE Rate Flag
1427: body_block :=
1428: '''AND ghr.entity_id = '' || p_entity_id || g_nl ||

Line 1446: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list('''AND ghr.', ' = fb.', ''' || g_nl ||', line_num, 'F');

1442: curr_pos := curr_pos + g_line_size;
1443: line_num := line_num + 1;
1444: END LOOP;
1445:
1446: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list('''AND ghr.', ' = fb.', ''' || g_nl ||', line_num, 'F');
1447:
1448: body_block :=
1449: ''''');
1450:

Line 1476: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb.', '', ' NULL,', line_num, 'F');

1472: curr_pos := curr_pos + g_line_size;
1473: line_num := line_num + 1;
1474: END LOOP;
1475:
1476: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb.', '', ' NULL,', line_num, 'F');
1477:
1478: body_block :=
1479: ' round(nvl(ghr.translated_amount * 0,
1480: nvl(decode(fxata.dim_attribute_varchar_member,

Line 1535: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb_in.', '', '', line_num, 'F');

1531: curr_pos := curr_pos + g_line_size;
1532: line_num := line_num + 1;
1533: END LOOP;
1534:
1535: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb_in.', '', '', line_num, 'F');
1536:
1537: body_block :=
1538: ' SUM(ptd_debit_balance_e) sum_ptd_debit_balance_e,
1539: SUM(ptd_credit_balance_e) sum_ptd_credit_balance_e,

Line 1560: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb_in.', '', '', line_num, 'F');

1556: curr_pos := curr_pos + g_line_size;
1557: line_num := line_num + 1;
1558: END LOOP;
1559:
1560: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb_in.', '', '', line_num, 'F');
1561:
1562: body_block :=
1563: ' fb_in.line_item_id) fb,
1564: FEM_BALANCES fbp,

Line 1593: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND fbp.', ' (+)= fb.', '', line_num, 'F');

1589: curr_pos := curr_pos + g_line_size;
1590: line_num := line_num + 1;
1591: END LOOP;
1592:
1593: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND fbp.', ' (+)= fb.', '', line_num, 'F');
1594:
1595: --Bugfix 6111815: Added Standard RE Rate Flag
1596: body_block :=
1597: ' AND ghr.entity_id = p_entity_id

Line 1615: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr.', ' = fb.', '', line_num, 'F');

1611: curr_pos := curr_pos + g_line_size;
1612: line_num := line_num + 1;
1613: END LOOP;
1614:
1615: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr.', ' = fb.', '', line_num, 'F');
1616:
1617: body_block :=
1618: ' ;
1619:

Line 1647: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list('''fb.', ' '' ||', '''NULL, '' ||', line_num, 'F');

1643: curr_pos := curr_pos + g_line_size;
1644: line_num := line_num + 1;
1645: END LOOP;
1646:
1647: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list('''fb.', ' '' ||', '''NULL, '' ||', line_num, 'F');
1648:
1649: body_block :=
1650: 'g_nl ||
1651: ''round(nvl(ghr.translated_amount * 0,'' || g_nl ||

Line 1707: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(''' fb_in.', ' '' ||', '', line_num, 'F');

1703: curr_pos := curr_pos + g_line_size;
1704: line_num := line_num + 1;
1705: END LOOP;
1706:
1707: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(''' fb_in.', ' '' ||', '', line_num, 'F');
1708:
1709: body_block :=
1710: ''' ptd_debit_balance_e sum_ptd_debit_balance_e,'' || g_nl ||
1711: '' ptd_credit_balance_e sum_ptd_credit_balance_e,'' || g_nl ||

Line 1750: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list('''AND fbp.', ' (+)= fb.', ''' || g_nl ||', line_num, 'F');

1746: curr_pos := curr_pos + g_line_size;
1747: line_num := line_num + 1;
1748: END LOOP;
1749:
1750: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list('''AND fbp.', ' (+)= fb.', ''' || g_nl ||', line_num, 'F');
1751:
1752: --Bugfix 6111815: Added Standard RE Rate Flag
1753: body_block :=
1754: '''AND ghr.entity_id = '' || p_entity_id || g_nl ||

Line 1773: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list('''AND ghr.', ' = fb.', ''' || g_nl ||', line_num, 'F');

1769: line_num := line_num + 1;
1770: END LOOP;
1771:
1772: --Bugfix 6111815: Removing Outer Join Condition
1773: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list('''AND ghr.', ' = fb.', ''' || g_nl ||', line_num, 'F');
1774:
1775: body_block :=
1776: ''''');
1777:

Line 1803: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb.', '', ' NULL,', line_num, 'F');

1799: curr_pos := curr_pos + g_line_size;
1800: line_num := line_num + 1;
1801: END LOOP;
1802:
1803: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb.', '', ' NULL,', line_num, 'F');
1804:
1805: body_block :=
1806: ' round(nvl(ghr.translated_amount * 0,
1807: nvl(decode(fxata.dim_attribute_varchar_member,

Line 1862: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb_in.', '', '', line_num, 'F');

1858: curr_pos := curr_pos + g_line_size;
1859: line_num := line_num + 1;
1860: END LOOP;
1861:
1862: line_num := GCS_TRANS_DYN_BUILD_PKG.build_comma_list(' fb_in.', '', '', line_num, 'F');
1863:
1864: body_block :=
1865: ' ptd_debit_balance_e sum_ptd_debit_balance_e,
1866: ptd_credit_balance_e sum_ptd_credit_balance_e,

Line 1905: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND fbp.', ' (+)= fb.', '', line_num, 'F');

1901: curr_pos := curr_pos + g_line_size;
1902: line_num := line_num + 1;
1903: END LOOP;
1904:
1905: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND fbp.', ' (+)= fb.', '', line_num, 'F');
1906:
1907: --Bugfix 6111815: Removed Outer Joins and Added Standard RE Rate Flag Condition
1908: body_block :=
1909: ' AND ghr.entity_id = p_entity_id

Line 1927: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr.', ' = fb.', '', line_num, 'F');

1923: curr_pos := curr_pos + g_line_size;
1924: line_num := line_num + 1;
1925: END LOOP;
1926:
1927: line_num := GCS_TRANS_DYN_BUILD_PKG.build_join_list(' AND ghr.', ' = fb.', '', line_num, 'F');
1928:
1929: body_block :=
1930: ' ;
1931: