APPS.JA_CN_APAB_EXPORT_PKG dependencies on JA_CN_LEDGER_LE_BSV_GT

Line 183: FROM ja_cn_ledger_le_bsv_gt

179: AND account_segment = :3
180: AND ledger_id = :4
181: AND company_segment IN
182: (SELECT bal_seg_value
183: FROM ja_cn_ledger_le_bsv_gt
184: WHERE legal_entity_id = :5)
185: GROUP BY account_segment,currency_code,period_mon,account_type,PERIOD_NAME,
186: segment1,segment2,segment3,segment4,segment5,
187: segment6,segment7,segment8,segment9,segment10,

Line 218: FROM ja_cn_ledger_le_bsv_gt

214: SELECT DISTINCT account_segment
215: FROM ja_cn_account_balances_v
216: WHERE company_segment IN
217: (SELECT bal_seg_value--segment_value
218: FROM ja_cn_ledger_le_bsv_gt
219: WHERE legal_entity_id = pn_legal_entity_id
220: AND chart_of_accounts_id = pn_coa_id)
221: AND period_name IN
222: (SELECT period_name

Line 279: --Populate balancing segment values to table ja_cn_ledger_le_bsv_gt

275: 'pn_coa_id=' || pn_coa_id || ',' ||
276: 'pv_period_from=' || pv_period_from || ',' ||
277: 'pv_period_to=' || pv_period_to);
278:
279: --Populate balancing segment values to table ja_cn_ledger_le_bsv_gt
280: DELETE FROM JA_CN_LEDGER_LE_BSV_GT;
281: COMMIT;
282: IF Ja_Cn_Utility.Populate_Ledger_Le_Bsv_Gt(pn_Ledger_Id,pn_legal_entity_id) <> 'S'
283: THEN

Line 280: DELETE FROM JA_CN_LEDGER_LE_BSV_GT;

276: 'pv_period_from=' || pv_period_from || ',' ||
277: 'pv_period_to=' || pv_period_to);
278:
279: --Populate balancing segment values to table ja_cn_ledger_le_bsv_gt
280: DELETE FROM JA_CN_LEDGER_LE_BSV_GT;
281: COMMIT;
282: IF Ja_Cn_Utility.Populate_Ledger_Le_Bsv_Gt(pn_Ledger_Id,pn_legal_entity_id) <> 'S'
283: THEN
284: RETURN;