DBA Data[Home] [Help]

APPS.JA_CN_POST_UTILITY_PKG dependencies on JA_CN_CFS_DATA_CLT_PKG

Line 1588: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(jcc.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value

1584: AND nvl(jcc1.SEGMENT30,'0')= nvl(jcc.SEGMENT30,'0')
1585: --BSV condition
1586: AND EXISTS (SELECT llbg.Bal_Seg_Value
1587: FROM ja_cn_ledger_le_bsv_gt llbg
1588: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(jcc.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value
1589: AND llbg.Ledger_Id = p_ledger_id --parameter: p_ledger_id
1590: AND llbg.Legal_Entity_Id = p_legal_entity_id) --parameter: p_legal_entity_id
1591: GROUP BY jcc.company_segment
1592: , jcp.period_name