APPS.FUN_BAL_UTILS_GRP dependencies on FUN_BALANCE_OPTIONS

Line 425: FROM fun_balance_options opts

421: p_source_name VARCHAR2,
422: p_category_name VARCHAR2)
423: IS
424: SELECT NVL((SELECT opts.template_id
425: FROM fun_balance_options opts
426: WHERE opts.ledger_id = p_ledger_id
427: AND Nvl(opts.le_id,-99) = Nvl(p_le_id,-99)
428: AND opts.je_source_name = p_source_name
429: AND opts.je_category_name = p_category_name

Line 432: FROM fun_balance_options opts

428: AND opts.je_source_name = p_source_name
429: AND opts.je_category_name = p_category_name
430: AND opts.status_flag = 'Y'),
431: NVL((SELECT opts.template_id
432: FROM fun_balance_options opts
433: WHERE opts.ledger_id = p_ledger_id
434: AND Nvl(opts.le_id,-99) = Nvl(p_le_id,-99)
435: AND opts.je_source_name = p_source_name
436: AND opts.je_category_name = 'Other'

Line 439: FROM fun_balance_options opts

435: AND opts.je_source_name = p_source_name
436: AND opts.je_category_name = 'Other'
437: AND opts.status_flag = 'Y'),
438: NVL((SELECT opts.template_id
439: FROM fun_balance_options opts
440: WHERE opts.ledger_id = p_ledger_id
441: AND Nvl(opts.le_id,-99) = Nvl(p_le_id,-99)
442: AND opts.je_source_name = 'Other'
443: AND opts.je_category_name = p_category_name

Line 446: FROM fun_balance_options opts

442: AND opts.je_source_name = 'Other'
443: AND opts.je_category_name = p_category_name
444: AND opts.status_flag = 'Y'),
445: (SELECT opts.template_id
446: FROM fun_balance_options opts
447: WHERE opts.ledger_id = p_ledger_id
448: AND Nvl(opts.le_id,-99) = Nvl(p_le_id,-99)
449: AND opts.je_source_name = 'Other'
450: AND opts.je_category_name = 'Other'

Line 1141: FROM fun_balance_options opts

1137: p_source_name VARCHAR2,
1138: p_category_name VARCHAR2)
1139: IS
1140: SELECT NVL((SELECT opts.template_id
1141: FROM fun_balance_options opts
1142: WHERE opts.ledger_id = p_ledger_id
1143: AND Nvl(opts.le_id,-99) = Nvl(p_le_id,-99)
1144: AND opts.je_source_name = p_source_name
1145: AND opts.je_category_name = p_category_name

Line 1148: FROM fun_balance_options opts

1144: AND opts.je_source_name = p_source_name
1145: AND opts.je_category_name = p_category_name
1146: AND opts.status_flag = 'Y'),
1147: NVL((SELECT opts.template_id
1148: FROM fun_balance_options opts
1149: WHERE opts.ledger_id = p_ledger_id
1150: AND Nvl(opts.le_id,-99) = Nvl(p_le_id,-99)
1151: AND opts.je_source_name = p_source_name
1152: AND opts.je_category_name = 'Other'

Line 1155: FROM fun_balance_options opts

1151: AND opts.je_source_name = p_source_name
1152: AND opts.je_category_name = 'Other'
1153: AND opts.status_flag = 'Y'),
1154: NVL((SELECT opts.template_id
1155: FROM fun_balance_options opts
1156: WHERE opts.ledger_id = p_ledger_id
1157: AND Nvl(opts.le_id,-99) = Nvl(p_le_id,-99)
1158: AND opts.je_source_name = 'Other'
1159: AND opts.je_category_name = p_category_name

Line 1162: FROM fun_balance_options opts

1158: AND opts.je_source_name = 'Other'
1159: AND opts.je_category_name = p_category_name
1160: AND opts.status_flag = 'Y'),
1161: (SELECT opts.template_id
1162: FROM fun_balance_options opts
1163: WHERE opts.ledger_id = p_ledger_id
1164: AND Nvl(opts.le_id,-99) = Nvl(p_le_id,-99)
1165: AND opts.je_source_name = 'Other'
1166: AND opts.je_category_name = 'Other'