APPS.JA_CN_AR_RBD_EXPORT_PKG dependencies on JA_CN_CFS_DATA_CLT_PKG

Line 1279: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Ael.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value

1275: AND Jcc.Code_Combination_Id = Ael.Code_Combination_Id
1276: --BSV condition, to handle one invoice having BSVs from different legal entity in distribution lines
1277: AND EXISTS (SELECT llbg.Bal_Seg_Value
1278: FROM ja_cn_ledger_le_bsv_gt llbg
1279: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Ael.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value
1280: AND llbg.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
1281: AND llbg.Legal_Entity_Id = pn_legal_entity_id) --parameter: pn_legal_entity_id
1282: )
1283: ORDER BY Account_Number;

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

1481: AND ael.accounting_class_code = 'RECEIVABLE'--accountingclass is 'Receivable' in the accounting line in SLA
1482: --BSV Condition
1483: AND EXISTS (SELECT llbg.Bal_Seg_Value
1484: FROM ja_cn_ledger_le_bsv_gt llbg
1485: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Jcc.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value
1486: AND llbg.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
1487: AND llbg.Legal_Entity_Id = pn_legal_entity_id) --parameter: pn_legal_entity_id
1488: --Period condition
1489: AND Gl.Ledger_Id = Jcc.ledger_id

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

1719: AND ael.accounting_class_code = 'RECEIVABLE'--accountingclass is 'Receivable' in the accounting line in SLA
1720: --BSV Condition
1721: AND EXISTS (SELECT llbg.Bal_Seg_Value
1722: FROM ja_cn_ledger_le_bsv_gt llbg
1723: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Jcc.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value
1724: AND llbg.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
1725: AND llbg.Legal_Entity_Id = pn_legal_entity_id) --parameter: pn_legal_entity_id
1726: --ld_start_date and ld_end_date come from pv_accounting_year, pv_period_from, pv_period_to
1727: AND gps.application_id = 101

Line 2319: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Ael.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value

2315: AND Aeh.Ae_Header_Id = ln_ae_header_id --variable: ln_ae_header_id
2316: --BSV condition, one transaction having BSVs with different legal entity in distribution lines????
2317: AND EXISTS (SELECT llbg.Bal_Seg_Value
2318: FROM ja_cn_ledger_le_bsv_gt llbg
2319: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Ael.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value
2320: AND llbg.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
2321: AND llbg.Legal_Entity_Id = pn_legal_entity_id); --parameter: pn_legal_entity_id
2322:
2323:

Line 2354: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Ael.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value

2350: )
2351: --BSV condition, one transaction having BSVs with different legal entity in distribution lines
2352: AND EXISTS (SELECT llbg.Bal_Seg_Value
2353: FROM ja_cn_ledger_le_bsv_gt llbg
2354: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Ael.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value
2355: AND llbg.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
2356: AND llbg.Legal_Entity_Id = pn_legal_entity_id); --parameter: pn_legal_entity_i
2357:
2358: --Cursor for fetching 'Functional Amount' and 'Entered Amount' of Credit Memo from SLA

Line 2374: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Ael.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value

2370: AND Ael.Ae_Line_Num = ln_ae_line_num
2371: --BSV condition, one transaction having BSVs with different legal entity in distribution lines????
2372: AND EXISTS (SELECT llbg.Bal_Seg_Value
2373: FROM ja_cn_ledger_le_bsv_gt llbg
2374: WHERE JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(Ael.CODE_COMBINATION_ID) = llbg.Bal_Seg_Value
2375: AND llbg.Ledger_Id = pn_ledger_id --parameter: pn_ledger_id
2376: AND llbg.Legal_Entity_Id = pn_legal_entity_id); --parameter: pn_legal_entity_id
2377:
2378: --Cursor for getting the Attribute Column for storing the Remittance Bill Number and Balance Side