APPS.JA_CN_HISDATA_MIG_PKG dependencies on JA_CN_VOUCHER_NUM_PKG

Line 42: --| get_balancing_segment with JA_CN_VOUCHER_NUM_PKG|

38: --| 21-Apr-2011 Jianchao Chi updated, fix bug 12353563 |
39: --| 26-Apr-2011 Chongwu Li updated, performance optimization |
40: --| 12-May-2011 Chongwu Li Updated for CFS seperated patch|
41: --| replace ja_cn_utility invoke for this method |
42: --| get_balancing_segment with JA_CN_VOUCHER_NUM_PKG|
43: --| tracked by bug 12541220 |
44: --+======================================================================*/
45:
46: GV_MODULE_PREFIX VARCHAR2(100) := 'JA_CN_HISDATA_MIG_PKG';

Line 107: WHERE JA_CN_VOUCHER_NUM_PKG.get_balancing_segment(gjl.code_combination_id) =

103: AND gjh.period_name = gjl.period_name
104: AND EXISTS
105: (SELECT jclllbg.bal_seg_value
106: FROM ja_cn_ledger_le_bsv_gt jclllbg
107: WHERE JA_CN_VOUCHER_NUM_PKG.get_balancing_segment(gjl.code_combination_id) =
108: jclllbg.bal_seg_value
109: AND jclllbg.Ledger_Id = ' ||
110: pn_ledger_id || '
111: AND jclllbg.Legal_Entity_Id = ' ||

Line 399: WHERE JA_CN_VOUCHER_NUM_PKG.get_balancing_segment(gjl.code_combination_id) =

395: AND gjl.period_name = pv_period_name
396: AND EXISTS
397: (SELECT jclllbg.bal_seg_value
398: FROM ja_cn_ledger_le_bsv_gt jclllbg
399: WHERE JA_CN_VOUCHER_NUM_PKG.get_balancing_segment(gjl.code_combination_id) =
400: jclllbg.bal_seg_value
401: AND jclllbg.Ledger_Id = pn_ledger_id
402: AND jclllbg.Legal_Entity_Id = pn_legal_entitliy_id)
403: AND gjl.Global_Attribute7 IS NULL