APPS.JA_CN_ACC_JE_ITEMIZATION_PKG dependencies on JA_CN_LEDGER_LE_BSV_GT

Line 372: ' ,ja_cn_ledger_le_bsv_gt bsv' ||

368: ' ,gl_je_lines jel' ||
369: ' ,gl_code_combinations gcc' ||
370: ' ,gl_periods gp' ||
371: ' ,gl_ledgers led' ||
372: ' ,ja_cn_ledger_le_bsv_gt bsv' ||
373: ' WHERE jeh.je_header_id = jel.je_header_id' ||
374: ' AND jeh.status = ''P''' ||
375: ' AND jeh.period_name = gp.period_name' ||
376: ' AND jel.code_combination_id = gcc.code_combination_id' ||

Line 1062: FROM ja_cn_ledger_le_bsv_gt bsv

1058: WHERE Je_Header_Id = l_Je_Header_Id
1059: AND Journal_Number IS NOT NULL
1060: AND Company_Segment IN
1061: (SELECT bsv.bal_seg_value
1062: FROM ja_cn_ledger_le_bsv_gt bsv
1063: WHERE Legal_Entity_Id = l_Legal_Entity_Id
1064: and ledger_id = l_ledger_id);
1065:
1066: BEGIN

Line 1097: FROM ja_cn_ledger_le_bsv_gt bsv

1093: WHERE Je_Header_Id = l_Je_Header_Id
1094: AND Journal_Number IS NULL
1095: AND Company_Segment IN
1096: (SELECT bsv.bal_seg_value
1097: FROM ja_cn_ledger_le_bsv_gt bsv
1098: WHERE Legal_Entity_Id = l_Legal_Entity_Id
1099: and ledger_id = l_ledger_id);
1100: ELSE
1101: CLOSE c_Journal_Appending;

Line 1116: FROM ja_cn_ledger_le_bsv_gt bsv

1112: SET Journal_Number = l_Journal_Number
1113: WHERE Je_Header_Id = l_Je_Header_Id
1114: AND Company_Segment IN
1115: (SELECT bsv.bal_seg_value
1116: FROM ja_cn_ledger_le_bsv_gt bsv
1117: WHERE Legal_Entity_Id = l_Legal_Entity_Id
1118: and ledger_id = l_ledger_id);
1119: END IF;
1120: