APPS.JA_CN_AP_VALIDATION_PKG dependencies on JA_CN_LEDGER_LE_BSV_GT

Line 253: FROM ja_cn_ledger_le_bsv_gt llbg

249: AND Ent.Entity_Id = Aeh.Entity_Id
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;

Line 315: FROM ja_cn_ledger_le_bsv_gt llbg

311: AND NVL(Sup.Vendor_Type_Lookup_Code, 'CUSTOMER') <> 'EMPLOYEE' --not considering employee supplier
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;

Line 386: --Step0: Populate balancing segment values to table ja_cn_ledger_le_bsv_gt

382: 'pv_accounting_year=' || pv_accounting_year || ',' ||
383: 'pv_period_from=' || pv_period_from || ',' ||
384: 'pv_period_to=' || pv_period_to);
385:
386: --Step0: Populate balancing segment values to table ja_cn_ledger_le_bsv_gt
387: DELETE
388: FROM JA_CN_LEDGER_LE_BSV_GT;
389: COMMIT ;
390: IF ja_cn_utility.populate_ledger_le_bsv_gt(pn_ledger_id, pn_legal_entity_id) <> 'S'

Line 388: FROM JA_CN_LEDGER_LE_BSV_GT;

384: 'pv_period_to=' || pv_period_to);
385:
386: --Step0: Populate balancing segment values to table ja_cn_ledger_le_bsv_gt
387: DELETE
388: FROM JA_CN_LEDGER_LE_BSV_GT;
389: COMMIT ;
390: IF ja_cn_utility.populate_ledger_le_bsv_gt(pn_ledger_id, pn_legal_entity_id) <> 'S'
391: THEN
392: RETURN;