APPS.JA_CN_AR_VALIDATION_PKG dependencies on JA_CN_LEDGER_LE_BSV_GT

Line 129: FROM ja_cn_ledger_le_bsv_gt llbg

125: AND ael.accounting_class_code = 'RECEIVABLE'--accountingclass is 'Receivable' in the accounting line in SLA
126: --BSV Condition
127: AND rct.legal_entity_id = pn_legal_entity_id
128: AND NOT EXISTS (SELECT llbg.Bal_Seg_Value
129: FROM ja_cn_ledger_le_bsv_gt llbg
130: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Jcc.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value
131: AND llbg.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
132: AND llbg.Legal_Entity_Id = pn_legal_entity_id) --parameter: pn_legal_entity_id
133: --ld_start_date and ld_end_date come from pv_accounting_year, pv_period_from, pv_period_to

Line 187: FROM ja_cn_ledger_le_bsv_gt llbg

183: AND NVL(Jel.Global_Attribute7,'*') <> 'P' --not itemized
184: AND ael.accounting_class_code = 'RECEIVABLE'
185: --BSV Condition
186: AND EXISTS (SELECT llbg.Bal_Seg_Value
187: FROM ja_cn_ledger_le_bsv_gt llbg
188: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Jcc.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value
189: AND llbg.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
190: AND llbg.Legal_Entity_Id = pn_legal_entity_id) --parameter: pn_legal_entity_id
191: --ld_start_date and ld_end_date come from pv_accounting_year, pv_period_from, pv_period_to

Line 277: --1. Populate balancing segment values to table ja_cn_ledger_le_bsv_gt

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

Line 278: DELETE FROM JA_CN_LEDGER_LE_BSV_GT;

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