APPS.JA_CN_HISDATA_MIG_PKG dependencies on JA_CN_SUB_ACC_MAPPING

Line 552: FROM ja_cn_sub_acc_mapping sam

548: CURSOR cur_setups IS
549: SELECT sam.subsidiary_segment_code,
550: sam.sources_code,
551: sam.context_code
552: FROM ja_cn_sub_acc_mapping sam
553: WHERE (chart_of_accounts_id = pn_chart_account_id)
554: AND context_code in
555: ('CUSTOMER',
556: 'SUPPLIER',

Line 628: FROM ja_cn_sub_acc_mapping sam

624: lv_procedure_name || 'lv_costcenter_seg = ' ||
625: lv_costcenter_seg);
626: \*SELECT count(*)--Comment by Jianchao Chi for bug 11683977
627: INTO ln_Subsidiary_number
628: FROM ja_cn_sub_acc_mapping sam
629: WHERE (chart_of_accounts_id = pn_chart_account_id)
630: and context_code in
631: ('CUSTOMER', 'SUPPLIER', 'EMPLOYEE_SUPPLIER',
632: (SELECT application_column_name

Line 918: FROM ja_cn_sub_acc_mapping sam

914: 'P_LEGAL_ENTITY_ID=' || P_LEGAL_ENTITY_ID);
915:
916: SELECT count(*) -- Moved from UpdateItemizationlines function by Jianchao Chi for bug 11683977
917: INTO ln_Subsidiary_number
918: FROM ja_cn_sub_acc_mapping sam
919: WHERE (chart_of_accounts_id = P_COA_ID)
920: and context_code in
921: ('CUSTOMER',
922: 'SUPPLIER',

Line 1245: FROM ja_cn_sub_acc_mapping sam

1241: 'P_LEGAL_ENTITY_ID=' || P_LEGAL_ENTITY_ID);
1242:
1243: SELECT count(*) -- Moved from UpdateItemizationlines function by Jianchao Chi for bug 11683977
1244: INTO ln_Subsidiary_number
1245: FROM ja_cn_sub_acc_mapping sam
1246: WHERE (chart_of_accounts_id = P_COA_ID)
1247: and context_code in
1248: ('CUSTOMER',
1249: 'SUPPLIER',

Line 1282: FROM ja_cn_sub_acc_mapping sam

1278:
1279: BEGIN
1280: SELECT sam.subsidiary_segment_code
1281: INTO lv_prject_project_seg
1282: FROM ja_cn_sub_acc_mapping sam
1283: WHERE (sam.chart_of_accounts_id = P_COA_ID)
1284: AND sam.context_code = 'PROJECT_NUMBER'
1285: AND sam.sources_code = 'PROJECT MODULE';
1286: EXCEPTION

Line 1297: FROM ja_cn_sub_acc_mapping sam

1293: BEGIN
1294:
1295: SELECT sam.subsidiary_segment_code
1296: INTO lv_prject_coa_seg
1297: FROM ja_cn_sub_acc_mapping sam
1298: WHERE sam.sources_code = 'COA'
1299: AND sam.chart_of_accounts_id = P_COA_ID
1300: AND sam.context_code IN
1301: (SELECT application_column_name

Line 1564: FROM ja_cn_sub_acc_mapping sam

1560: CURSOR cur_setups IS
1561: SELECT sam.subsidiary_segment_code,
1562: sam.sources_code,
1563: sam.context_code
1564: FROM ja_cn_sub_acc_mapping sam
1565: WHERE (chart_of_accounts_id = pn_chart_account_id)
1566: AND context_code in
1567: ('CUSTOMER',
1568: 'SUPPLIER',