APPS.JA_CN_AR_VALIDATION_PKG dependencies on JA_CN_CFS_DATA_CLT_PKG

Line 100: JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(jcc.code_combination_id) Bal_Seg_Value

96: gps.period_name Period_Name,
97: part.party_number Customer_Number,
98: part.party_name Customer_Name,
99: rct.trx_number Transaction_Number,
100: JA_CN_CFS_DATA_CLT_PKG.get_balancing_segment(jcc.code_combination_id) Bal_Seg_Value
101: FROM GL_JE_HEADERS jeh,
102: GL_JE_LINES jel,
103: GL_IMPORT_REFERENCES gir,
104: XLA_AE_LINES ael,

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

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
134: AND gps.application_id = 101

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

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
192: AND gps.application_id = 101