DBA Data[Home] [Help]

APPS.FEM_GL_POST_BAL_PKG dependencies on FEM_INTG_DELTA_LOADS

Line 308: ' FROM FEM_INTG_DELTA_LOADS dl ' ||

304: ' AND param.request_id IS NOT NULL ' ||
305: ' AND cc.code_combination_id = bpi.code_combination_id ' ||
306: ' AND NOT EXISTS ' ||
307: ' (SELECT 1 ' ||
308: ' FROM FEM_INTG_DELTA_LOADS dl ' ||
309: ' WHERE dl.ledger_id = bpi.ledger_id ' ||
310: ' AND dl.dataset_code = bpi.dataset_code ' ||
311: ' AND dl.cal_period_id = bpi.cal_period_id ' ||
312: ' AND dl.delta_run_id = bpi.delta_run_id ' ||

Line 442: ' FROM FEM_INTG_DELTA_LOADS dl ' ||

438: 'AND pi.posting_error_flag = ''N'' ' ||
439: 'AND cc.code_combination_id = pi.code_combination_id ' ||
440: 'AND NOT EXISTS ' ||
441: '(SELECT 1 ' ||
442: ' FROM FEM_INTG_DELTA_LOADS dl ' ||
443: ' WHERE dl.ledger_id = pi.ledger_id ' ||
444: ' AND dl.dataset_code = pi.dataset_code ' ||
445: ' AND dl.cal_period_id = pi.cal_period_id ' ||
446: ' AND dl.delta_run_id = pi.delta_run_id ' ||

Line 647: FROM FEM_INTG_DELTA_LOADS dl

643: FROM FEM_BAL_POST_INTERIM_GT bpi
644: WHERE posting_error_flag = 'N'
645: AND NOT EXISTS
646: (SELECT 1
647: FROM FEM_INTG_DELTA_LOADS dl
648: WHERE dl.ledger_id = bpi.ledger_id
649: AND dl.dataset_code = bpi.dataset_code
650: AND dl.cal_period_id = bpi.cal_period_id
651: AND dl.delta_run_id = bpi.delta_run_id