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.FUN_BAL_PKG dependencies on FUN_BALANCE_ACCOUNTS

Line 1999: FROM fun_balance_accounts accts

1995: --ER: 8588074
1996: --Bug: 9183927
1997: UPDATE fun_bal_inter_int_gt inter_int
1998: SET rec_acct = (SELECT dr_ccid
1999: FROM fun_balance_accounts accts
2000: WHERE
2001: 'OTHER1234567890123456789012345' = accts.cr_bsv
2002: AND 'OTHER1234567890123456789012345' = accts.dr_bsv
2003: AND accts.template_id = (SELECT NVL((SELECT opts.template_id

Line 2270: FROM fun_balance_accounts accts

2266: -- ER: 8588074
2267: --Bug: 9183927
2268: UPDATE fun_bal_inter_int_gt inter_int
2269: SET pay_acct = (SELECT cr_ccid
2270: FROM fun_balance_accounts accts
2271: WHERE
2272: 'OTHER1234567890123456789012345' = accts.cr_bsv
2273: AND 'OTHER1234567890123456789012345' = accts.dr_bsv
2274: AND accts.template_id = (SELECT NVL((SELECT opts.template_id

Line 3221: FROM fun_balance_accounts accts

3217: -- Update ccid for each DB BSV and CR BSV /* change here */
3218: UPDATE fun_bal_le_bsv_map_gt le_bsv_map
3219: SET (dr_cr_debit_ccid, dr_cr_credit_ccid, dr_cr_debit_complete, dr_cr_credit_complete) =
3220: (SELECT dr_ccid, cr_ccid, 'N', 'N'
3221: FROM fun_balance_accounts accts
3222: WHERE le_bsv_map.template_id = accts.template_id
3223: AND ((le_bsv_map.intracompany_mode = 5
3224: AND le_bsv_map.bal_seg_val = accts.dr_bsv
3225: AND le_bsv_map.clearing_bsv = accts.cr_bsv)

Line 3242: FROM fun_balance_accounts accts

3238:
3239: UPDATE fun_bal_le_bsv_map_gt le_bsv_map
3240: SET (dr_cr_debit_ccid, dr_cr_credit_ccid, dr_cr_debit_complete, dr_cr_credit_complete) =
3241: (SELECT dr_ccid, cr_ccid, 'N','N' /* Bug 14565212 Set _complete to N for all cases */
3242: FROM fun_balance_accounts accts
3243: WHERE le_bsv_map.template_id = accts.template_id
3244: AND ((le_bsv_map.intracompany_mode = 5
3245: AND 'OTHER1234567890123456789012345' = accts.cr_bsv
3246: AND le_bsv_map.bal_seg_val = accts.dr_bsv)

Line 3255: FROM fun_balance_accounts accts

3251:
3252: UPDATE fun_bal_le_bsv_map_gt le_bsv_map
3253: SET (dr_cr_debit_ccid, dr_cr_credit_ccid, dr_cr_debit_complete, dr_cr_credit_complete) =
3254: (SELECT dr_ccid, cr_ccid, 'N','N' /* Bug 14565212 Set _complete to N for all cases */
3255: FROM fun_balance_accounts accts
3256: WHERE le_bsv_map.template_id = accts.template_id
3257: AND ((le_bsv_map.intracompany_mode = 5
3258: AND le_bsv_map.clearing_bsv = accts.cr_bsv
3259: AND 'OTHER1234567890123456789012345' = accts.dr_bsv)

Line 3276: FROM fun_balance_accounts accts

3272:
3273: UPDATE fun_bal_le_bsv_map_gt le_bsv_map
3274: SET (dr_cr_debit_ccid, dr_cr_credit_ccid, dr_cr_debit_complete, dr_cr_credit_complete) =
3275: (SELECT dr_ccid, cr_ccid, 'N', 'N'
3276: FROM fun_balance_accounts accts
3277: WHERE le_bsv_map.template_id = accts.template_id
3278: AND 'OTHER1234567890123456789012345' = accts.cr_bsv
3279: AND 'OTHER1234567890123456789012345' = accts.dr_bsv)
3280: WHERE dr_cr_debit_ccid IS NULL ;

Line 3286: FROM fun_balance_accounts accts

3282: -- Upating cr_dr_debit_ccid, cr_dr_credit_ccid
3283: UPDATE fun_bal_le_bsv_map_gt le_bsv_map
3284: SET (cr_dr_debit_ccid, cr_dr_credit_ccid, cr_dr_debit_complete, cr_dr_credit_complete) =
3285: (SELECT dr_ccid, cr_ccid, 'N', 'N'
3286: FROM fun_balance_accounts accts
3287: WHERE le_bsv_map.template_id = accts.template_id
3288: AND ((le_bsv_map.intracompany_mode = 5
3289: AND le_bsv_map.bal_seg_val = accts.cr_bsv
3290: AND le_bsv_map.clearing_bsv = accts.dr_bsv)

Line 3306: FROM fun_balance_accounts accts

3302:
3303: UPDATE fun_bal_le_bsv_map_gt le_bsv_map
3304: SET (cr_dr_debit_ccid, cr_dr_credit_ccid, cr_dr_debit_complete, cr_dr_credit_complete) =
3305: (SELECT dr_ccid, cr_ccid,'N','N'/* Bug 14565212 Set _complete to N for all cases */
3306: FROM fun_balance_accounts accts
3307: WHERE le_bsv_map.template_id = accts.template_id
3308: AND ((le_bsv_map.intracompany_mode = 5
3309: AND 'OTHER1234567890123456789012345' = accts.cr_bsv
3310: AND le_bsv_map.clearing_bsv = accts.dr_bsv)

Line 3327: FROM fun_balance_accounts accts

3323:
3324: UPDATE fun_bal_le_bsv_map_gt le_bsv_map
3325: SET (cr_dr_debit_ccid, cr_dr_credit_ccid, cr_dr_debit_complete, cr_dr_credit_complete) =
3326: (SELECT dr_ccid, cr_ccid, 'N', 'N'/* SN */
3327: FROM fun_balance_accounts accts
3328: WHERE le_bsv_map.template_id = accts.template_id
3329: AND ((le_bsv_map.intracompany_mode = 5
3330: AND 'OTHER1234567890123456789012345' = accts.dr_bsv
3331: AND le_bsv_map.bal_seg_val = accts.cr_bsv)

Line 3340: FROM fun_balance_accounts accts

3336:
3337: UPDATE fun_bal_le_bsv_map_gt le_bsv_map
3338: SET (cr_dr_debit_ccid, cr_dr_credit_ccid, cr_dr_debit_complete, cr_dr_credit_complete) =
3339: (SELECT dr_ccid, cr_ccid, 'N', 'N' /* SN */
3340: FROM fun_balance_accounts accts
3341: WHERE le_bsv_map.template_id = accts.template_id
3342: AND 'OTHER1234567890123456789012345' = accts.cr_bsv
3343: AND 'OTHER1234567890123456789012345' = accts.dr_bsv)
3344: WHERE cr_dr_debit_ccid IS NULL;