APPS.FUN_BAL_UTILS_GRP dependencies on FUN_BALANCE_OPTIONS

Line 827: FROM fun_balance_options opts

823: p_source_name VARCHAR2,
824: p_category_name VARCHAR2)
825: IS
826: SELECT NVL((SELECT opts.template_id
827: FROM fun_balance_options opts
828: WHERE opts.ledger_id = p_ledger_id
829: AND Nvl(opts.le_id,-99) = Nvl(p_le_id,-99)
830: AND opts.je_source_name = p_source_name
831: AND opts.je_category_name = p_category_name

Line 834: FROM fun_balance_options opts

830: AND opts.je_source_name = p_source_name
831: AND opts.je_category_name = p_category_name
832: AND opts.status_flag = 'Y'),
833: NVL((SELECT opts.template_id
834: FROM fun_balance_options opts
835: WHERE opts.ledger_id = p_ledger_id
836: AND Nvl(opts.le_id,-99) = Nvl(p_le_id,-99)
837: AND opts.je_source_name = p_source_name
838: AND opts.je_category_name = 'Other'

Line 841: FROM fun_balance_options opts

837: AND opts.je_source_name = p_source_name
838: AND opts.je_category_name = 'Other'
839: AND opts.status_flag = 'Y'),
840: NVL((SELECT opts.template_id
841: FROM fun_balance_options opts
842: WHERE opts.ledger_id = p_ledger_id
843: AND Nvl(opts.le_id,-99) = Nvl(p_le_id,-99)
844: AND opts.je_source_name = 'Other'
845: AND opts.je_category_name = p_category_name

Line 848: FROM fun_balance_options opts

844: AND opts.je_source_name = 'Other'
845: AND opts.je_category_name = p_category_name
846: AND opts.status_flag = 'Y'),
847: (SELECT opts.template_id
848: FROM fun_balance_options opts
849: WHERE opts.ledger_id = p_ledger_id
850: AND Nvl(opts.le_id,-99) = Nvl(p_le_id,-99)
851: AND opts.je_source_name = 'Other'
852: AND opts.je_category_name = 'Other'