APPS.JA_CN_UDR_EXPORT dependencies on JA_CN_SUB_ACC_MAPPING

Line 75: FROM ja_cn_sub_acc_mapping

71: CURSOR user_defined_records_cur(pn_ledger_id NUMBER,
72: pn_le_id NUMBER,
73: pv_accounting_year VARCHAR2) IS
74: SELECT subsidiary_segment_code, sources_code, context_code
75: FROM ja_cn_sub_acc_mapping
76: WHERE chart_of_accounts_id = pn_coa_id
77: AND sources_code in ('COA', 'PROJECT MODULE')
78: --choli add to fix bug 12392517
79: ORDER BY subsidiary_segment_code;

Line 184: JA_CN_SUB_ACC_MAPPING SAM

180: FROM FND_ID_FLEX_SEGMENTS FIFS,
181: FND_SEGMENT_ATTRIBUTE_VALUES FSAV,
182: GL_LEDGERS LED,
183: FND_FLEX_VALUE_SETS FFVS,
184: JA_CN_SUB_ACC_MAPPING SAM
185: WHERE FIFS.ID_FLEX_NUM = FSAV.ID_FLEX_NUM
186: AND FIFS.APPLICATION_COLUMN_NAME =
187: FSAV.APPLICATION_COLUMN_NAME
188: AND (FSAV.SEGMENT_ATTRIBUTE_TYPE <> 'GL_GLOBAL' OR