DBA Data[Home] [Help]

APPS.JA_CN_PS_FA_MI_EXP_PKG dependencies on JA_CN_LEDGER_LE_BSV_GT

Line 127: FROM ja_cn_ledger_le_bsv_gt jclllbg

123: AND (fdh.date_ineffective > fdp.period_open_date OR
124: fdh.date_ineffective IS NULL)
125: AND EXISTS
126: (SELECT jclllbg.bal_seg_value
127: FROM ja_cn_ledger_le_bsv_gt jclllbg
128: WHERE Ja_Cn_Utility.get_balancing_segment
129: (fdh.code_combination_id) = jclllbg.bal_seg_value
130: AND jclllbg.Ledger_Id = ln_ledger_id
131: AND jclllbg.Legal_Entity_Id = ln_legal_entity_id)

Line 258: FROM ja_cn_ledger_le_bsv_gt jclllbg

254: AND (fdh.date_ineffective > nvl(ld_dp_close_date, SYSDATE) OR
255: fdh.date_ineffective IS NULL)
256: AND EXISTS
257: (SELECT jclllbg.bal_seg_value
258: FROM ja_cn_ledger_le_bsv_gt jclllbg
259: WHERE JA_CN_CFS_DATA_CLT_PKG.
260: get_balancing_segment(fdh.code_combination_id) =
261: jclllbg.bal_seg_value
262: AND jclllbg.Ledger_Id = pn_ledger_id

Line 342: FROM ja_cn_ledger_le_bsv_gt jclllbg

338: AND (fdh.date_ineffective > nvl(ld_dp_close_date, SYSDATE) OR
339: fdh.date_ineffective IS NULL)
340: AND EXISTS
341: (SELECT jclllbg.bal_seg_value
342: FROM ja_cn_ledger_le_bsv_gt jclllbg
343: WHERE JA_CN_UTILITY.get_balancing_segment
344: (fdh.code_combination_id)= jclllbg.bal_seg_value
345: AND jclllbg.Ledger_Id = pn_ledger_id
346: AND jclllbg.Legal_Entity_Id = pn_legal_entity_id);