APPS.FUN_BAL_PKG dependencies on DUAL

Line 1199: SET (driving_dr_le_bsv, driving_cr_le_bsv)=(Select 'Many','Many' from Dual)

1195: );
1196:
1197: --updating the driving_dr_le_bsv ,driving_cr_le_bsv for the Many to many case #9392684
1198: Update fun_bal_inter_int2_gt
1199: SET (driving_dr_le_bsv, driving_cr_le_bsv)=(Select 'Many','Many' from Dual)
1200: where group_id IN (Select upd1.group_id from (select count(DISTINCT inter_int2.line_le_bsv) count1, group_id from fun_bal_inter_int2_gt inter_int2
1201: where type='D'
1202: GROUP by group_id) upd1,
1203: (select count(DISTINCT inter_int2.line_le_bsv) count1, group_id from fun_bal_inter_int2_gt inter_int2

Line 1527: SET (driving_dr_le_bsv, driving_cr_le_bsv)=(Select 'Many','Many' from Dual)

1523:
1524:
1525: --updating the driving_dr_le_bsv ,driving_cr_le_bsv for the Many to many case #9392684
1526: Update fun_bal_inter_int2_gt
1527: SET (driving_dr_le_bsv, driving_cr_le_bsv)=(Select 'Many','Many' from Dual)
1528: where group_id IN (Select upd1.group_id from (select count(DISTINCT inter_int2.line_le_bsv) count1, group_id from fun_bal_inter_int2_gt inter_int2
1529: where type='D'
1530: GROUP by group_id) upd1,
1531: (select count(DISTINCT inter_int2.line_le_bsv) count1, group_id from fun_bal_inter_int2_gt inter_int2

Line 2063: From Dual))

2059: NULL)
2060: AND opts.je_source_name = 'Other'
2061: AND opts.je_category_name = 'Other'
2062: AND opts.status_flag = 'Y')))) template_id
2063: From Dual))
2064: WHERE inter_int.rec_acct IS NULL and fun_trx_pvt.get_inter_intra()='Y';
2065:
2066: ---- end ER: 8588074
2067:

Line 2334: From Dual))

2330: NULL)
2331: AND opts.je_source_name = 'Other'
2332: AND opts.je_category_name = 'Other'
2333: AND opts.status_flag = 'Y')))) template_id
2334: From Dual))
2335: WHERE inter_int.pay_acct IS NULL and fun_trx_pvt.get_inter_intra()='Y';
2336: --- END ER: 8588074
2337: --FND_STATS.GATHER_TABLE_STATS(g_fun_schema, 'FUN_BAL_INTER_INT_GT');
2338: