APPS.JA_CN_VOUCHER_NUM_MIG_PKG dependencies on JA_CN_VOUCHER_NUM_PKG

Line 25: --| get_balancing_segment with JA_CN_VOUCHER_NUM_PKG|

21: --| 14-Jan-2011 Chongwu Li Updated CNAO V1 to V2 upgrade |
22: --| 24-Jan-2011 Jianchao Chi Update for bug 11670727 |
23: --| 12-May-2011 Chongwu Li Updated for CFS seperated patch|
24: --| replace ja_cn_utility invoke for this method |
25: --| get_balancing_segment with JA_CN_VOUCHER_NUM_PKG|
26: --| tracked by bug 12541220 |
27: --+======================================================================*/
28: GV_MODULE_PREFIX VARCHAR2(100) := 'JA_CN_VOUCHER_NUM_MIGRATION_PKG';
29:

Line 87: WHERE JA_CN_VOUCHER_NUM_PKG.get_balancing_segment(jcjl.code_combination_id) =

83: AND gjh.period_name = pv_period_name
84: AND EXISTS
85: (SELECT jclllbg.bal_seg_value
86: FROM ja_cn_ledger_le_bsv_gt jclllbg
87: WHERE JA_CN_VOUCHER_NUM_PKG.get_balancing_segment(jcjl.code_combination_id) =
88: jclllbg.bal_seg_value
89: AND jclllbg.Ledger_Id = pn_ledger_id
90: AND jclllbg.Legal_Entity_Id = pn_legal_entity_id)
91: AND NOT EXISTS

Line 156: WHERE JA_CN_VOUCHER_NUM_PKG.get_balancing_segment(jcjl.code_combination_id) =

152: AND gjh.period_name = pv_period_name
153: AND EXISTS
154: (SELECT jclllbg.bal_seg_value
155: FROM ja_cn_ledger_le_bsv_gt jclllbg
156: WHERE JA_CN_VOUCHER_NUM_PKG.get_balancing_segment(jcjl.code_combination_id) =
157: jclllbg.bal_seg_value
158: AND jclllbg.Ledger_Id = pn_ledger_id
159: AND jclllbg.Legal_Entity_Id = pn_legal_entity_id)
160: AND NOT EXISTS