APPS.JA_CN_AP_VALIDATION_PKG dependencies on JA_CN_CFS_DATA_CLT_PKG

Line 202: JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Jcc.CODE_COMBINATION_ID) Bal_Seg_Value

198: Gp.Start_date Start_Date,
199: Jeh.Period_Name Period_Name,
200: Sup.Vendor_Name Supplier_Name,
201: Aia.Invoice_Num Invoice_Number,
202: JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Jcc.CODE_COMBINATION_ID) Bal_Seg_Value
203: FROM Gl_Je_Lines Jel,
204: Gl_Je_Headers Jeh,
205: Gl_Import_References Gir,
206: Ja_Cn_Code_Combination_v Jcc,

Line 254: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Jcc.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value

250: --BSV condition
251: AND Aia.Legal_Entity_Id = pn_legal_entity_id --parameter: pn_legal_entity_id --Updated for fixing bug# 9763810
252: AND NOT EXISTS (SELECT llbg.Bal_Seg_Value
253: FROM ja_cn_ledger_le_bsv_gt llbg
254: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Jcc.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value
255: AND llbg.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
256: AND llbg.Legal_Entity_Id = pn_legal_entity_id) --parameter: pn_legal_entity_id
257: ORDER BY Gp.start_date, Ael.Party_Id;
258:

Line 316: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Jcc.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value

312: AND Ael.Accounting_Class_Code = 'LIABILITY' --only collecting 'Liability' account
313: --BSV condition
314: AND EXISTS (SELECT llbg.Bal_Seg_Value
315: FROM ja_cn_ledger_le_bsv_gt llbg
316: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Jcc.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value
317: AND llbg.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
318: AND llbg.Legal_Entity_Id = pn_legal_entity_id) --parameter: pn_legal_entity_id
319: ORDER BY Gp.start_date, Ael.Party_Id;
320: