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.

[Home] [Help]

APPS.FUN_BAL_PKG dependencies on FUN_BAL_INTER_INT3_GT

Line 1118: delete fun_bal_inter_int3_gt;

1114: -- Find out the balancing segment values for the dr le id
1115: -- This will set the value correctly where mode is 1 : 1 or 1 : M
1116: --Bug:12554299. Implemented the changes to handle the case for exchange gain/loss.
1117:
1118: delete fun_bal_inter_int3_gt;
1119:
1120: INSERT INTO fun_bal_inter_int3_gt(
1121: GROUP_ID,
1122: LEDGER_ID,

Line 1120: INSERT INTO fun_bal_inter_int3_gt(

1116: --Bug:12554299. Implemented the changes to handle the case for exchange gain/loss.
1117:
1118: delete fun_bal_inter_int3_gt;
1119:
1120: INSERT INTO fun_bal_inter_int3_gt(
1121: GROUP_ID,
1122: LEDGER_ID,
1123: LE_ID,
1124: ACCOUNTED_AMT_CR,

Line 1152: UPDATE fun_bal_inter_int3_gt upd

1148: LEDGER_ID,
1149: LE_ID,
1150: LINE_LE_BSV;
1151:
1152: UPDATE fun_bal_inter_int3_gt upd
1153: SET driving_dr_le_bsv =
1154: DECODE(upd.type, 'D', upd.line_le_bsv,
1155: 'C', DECODE((SELECT COUNT(DISTINCT cmp.line_le_bsv)
1156: FROM fun_bal_inter_int3_gt cmp

Line 1156: FROM fun_bal_inter_int3_gt cmp

1152: UPDATE fun_bal_inter_int3_gt upd
1153: SET driving_dr_le_bsv =
1154: DECODE(upd.type, 'D', upd.line_le_bsv,
1155: 'C', DECODE((SELECT COUNT(DISTINCT cmp.line_le_bsv)
1156: FROM fun_bal_inter_int3_gt cmp
1157: WHERE upd.group_id = cmp.group_id
1158: AND cmp.type='D'
1159: ),
1160: 1, (SELECT DISTINCT cmp1.line_le_bsv

Line 1161: FROM fun_bal_inter_int3_gt cmp1

1157: WHERE upd.group_id = cmp.group_id
1158: AND cmp.type='D'
1159: ),
1160: 1, (SELECT DISTINCT cmp1.line_le_bsv
1161: FROM fun_bal_inter_int3_gt cmp1
1162: WHERE upd.group_id = cmp1.group_id
1163: AND cmp1.type='D'
1164: ),'Many'));
1165:

Line 1167: UPDATE fun_bal_inter_int3_gt upd

1163: AND cmp1.type='D'
1164: ),'Many'));
1165:
1166:
1167: UPDATE fun_bal_inter_int3_gt upd
1168: SET driving_cr_le_bsv =
1169: DECODE(upd.type, 'C', upd.line_le_bsv,
1170: 'D', DECODE((SELECT COUNT(DISTINCT cmp.line_le_bsv)
1171: FROM fun_bal_inter_int3_gt cmp

Line 1171: FROM fun_bal_inter_int3_gt cmp

1167: UPDATE fun_bal_inter_int3_gt upd
1168: SET driving_cr_le_bsv =
1169: DECODE(upd.type, 'C', upd.line_le_bsv,
1170: 'D', DECODE((SELECT COUNT(DISTINCT cmp.line_le_bsv)
1171: FROM fun_bal_inter_int3_gt cmp
1172: WHERE upd.group_id = cmp.group_id
1173: AND cmp.type='C'
1174: ),
1175: 1, (SELECT DISTINCT cmp1.line_le_bsv

Line 1176: FROM fun_bal_inter_int3_gt cmp1

1172: WHERE upd.group_id = cmp.group_id
1173: AND cmp.type='C'
1174: ),
1175: 1, (SELECT DISTINCT cmp1.line_le_bsv
1176: FROM fun_bal_inter_int3_gt cmp1
1177: WHERE upd.group_id = cmp1.group_id
1178: AND cmp1.type='C'
1179: ),'Many'));
1180:

Line 1183: from fun_bal_inter_int3_gt dr_t3

1179: ),'Many'));
1180:
1181: update fun_bal_inter_int2_gt t2
1182: set driving_dr_le_bsv = (select driving_dr_le_bsv
1183: from fun_bal_inter_int3_gt dr_t3
1184: where dr_t3.group_id = t2.group_id
1185: and dr_t3.le_id = t2.le_id
1186: and dr_t3.line_le_bsv = t2.line_le_bsv
1187: );

Line 1191: from fun_bal_inter_int3_gt dr_t3

1187: );
1188:
1189: update fun_bal_inter_int2_gt t2
1190: set driving_cr_le_bsv = (select driving_cr_le_bsv
1191: from fun_bal_inter_int3_gt dr_t3
1192: where dr_t3.group_id = t2.group_id
1193: and dr_t3.le_id = t2.le_id
1194: and dr_t3.line_le_bsv = t2.line_le_bsv
1195: );

Line 1445: delete fun_bal_inter_int3_gt;

1441: AND ( driving_dr_le_bsv <>'Many'
1442: OR driving_cr_le_bsv <>'Many'); */
1443:
1444: --Bug:12554299. Implemented the changes to handle the case for exchange gain/loss.
1445: delete fun_bal_inter_int3_gt;
1446:
1447: INSERT INTO fun_bal_inter_int3_gt(
1448: GROUP_ID,
1449: LEDGER_ID,

Line 1447: INSERT INTO fun_bal_inter_int3_gt(

1443:
1444: --Bug:12554299. Implemented the changes to handle the case for exchange gain/loss.
1445: delete fun_bal_inter_int3_gt;
1446:
1447: INSERT INTO fun_bal_inter_int3_gt(
1448: GROUP_ID,
1449: LEDGER_ID,
1450: LE_ID,
1451: ACCOUNTED_AMT_CR,

Line 1479: UPDATE fun_bal_inter_int3_gt upd

1475: LEDGER_ID,
1476: LE_ID,
1477: LINE_LE_BSV;
1478:
1479: UPDATE fun_bal_inter_int3_gt upd
1480: SET driving_dr_le_bsv =
1481: DECODE(upd.type, 'D', upd.line_le_bsv,
1482: 'C', DECODE((SELECT COUNT(DISTINCT cmp.line_le_bsv)
1483: FROM fun_bal_inter_int3_gt cmp

Line 1483: FROM fun_bal_inter_int3_gt cmp

1479: UPDATE fun_bal_inter_int3_gt upd
1480: SET driving_dr_le_bsv =
1481: DECODE(upd.type, 'D', upd.line_le_bsv,
1482: 'C', DECODE((SELECT COUNT(DISTINCT cmp.line_le_bsv)
1483: FROM fun_bal_inter_int3_gt cmp
1484: WHERE upd.group_id = cmp.group_id
1485: AND cmp.type='D'
1486: ),
1487: 1, (SELECT DISTINCT cmp1.line_le_bsv

Line 1488: FROM fun_bal_inter_int3_gt cmp1

1484: WHERE upd.group_id = cmp.group_id
1485: AND cmp.type='D'
1486: ),
1487: 1, (SELECT DISTINCT cmp1.line_le_bsv
1488: FROM fun_bal_inter_int3_gt cmp1
1489: WHERE upd.group_id = cmp1.group_id
1490: AND cmp1.type='D'
1491: ),'Many'));
1492:

Line 1494: UPDATE fun_bal_inter_int3_gt upd

1490: AND cmp1.type='D'
1491: ),'Many'));
1492:
1493:
1494: UPDATE fun_bal_inter_int3_gt upd
1495: SET driving_cr_le_bsv =
1496: DECODE(upd.type, 'C', upd.line_le_bsv,
1497: 'D', DECODE((SELECT COUNT(DISTINCT cmp.line_le_bsv)
1498: FROM fun_bal_inter_int3_gt cmp

Line 1498: FROM fun_bal_inter_int3_gt cmp

1494: UPDATE fun_bal_inter_int3_gt upd
1495: SET driving_cr_le_bsv =
1496: DECODE(upd.type, 'C', upd.line_le_bsv,
1497: 'D', DECODE((SELECT COUNT(DISTINCT cmp.line_le_bsv)
1498: FROM fun_bal_inter_int3_gt cmp
1499: WHERE upd.group_id = cmp.group_id
1500: AND cmp.type='C'
1501: ),
1502: 1, (SELECT DISTINCT cmp1.line_le_bsv

Line 1503: FROM fun_bal_inter_int3_gt cmp1

1499: WHERE upd.group_id = cmp.group_id
1500: AND cmp.type='C'
1501: ),
1502: 1, (SELECT DISTINCT cmp1.line_le_bsv
1503: FROM fun_bal_inter_int3_gt cmp1
1504: WHERE upd.group_id = cmp1.group_id
1505: AND cmp1.type='C'
1506: ),'Many'));
1507:

Line 1510: from fun_bal_inter_int3_gt dr_t3

1506: ),'Many'));
1507:
1508: update fun_bal_inter_int2_gt t2
1509: set driving_dr_le_bsv = (select driving_dr_le_bsv
1510: from fun_bal_inter_int3_gt dr_t3
1511: where dr_t3.group_id = t2.group_id
1512: and dr_t3.le_id = t2.le_id
1513: and dr_t3.line_le_bsv = t2.line_le_bsv
1514: );

Line 1518: from fun_bal_inter_int3_gt dr_t3

1514: );
1515:
1516: update fun_bal_inter_int2_gt t2
1517: set driving_cr_le_bsv = (select driving_cr_le_bsv
1518: from fun_bal_inter_int3_gt dr_t3
1519: where dr_t3.group_id = t2.group_id
1520: and dr_t3.le_id = t2.le_id
1521: and dr_t3.line_le_bsv = t2.line_le_bsv
1522: );