eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_POST_UTILITY_PKG dependencies on GL_LEDGERS

Line 191: /*l_RET_EARN_CODE_COMBINATION_ID gl_ledgers.ret_earn_code_combination_id%TYPE;

187: l_prior_period_name gl_periods.period_name%TYPE;
188: l_prior_period_num ja_cn_periods.period_num%TYPE;
189:
190: l_period_month ja_cn_account_balances.period_mon%TYPE;
191: /*l_RET_EARN_CODE_COMBINATION_ID gl_ledgers.ret_earn_code_combination_id%TYPE;
192:
193: l_ret_company_segment ja_cn_account_balances.company_segment%TYPE;
194: l_ret_cost_center_seg ja_cn_account_balances.cost_center%TYPE;
195: l_ret_account_segment ja_cn_account_balances.account_segment%TYPE;

Line 268: , gl_ledgers led

264:
265: SELECT ifs.flex_value_set_id
266: INTO l_flex_value_set_id
267: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav
268: , gl_ledgers led
269: , Fnd_Id_Flex_Segments ifs
270: WHERE sav.SEGMENT_ATTRIBUTE_TYPE = 'GL_ACCOUNT'
271: AND sav.ID_FLEX_CODE = 'GL#'
272: AND sav.APPLICATION_ID = 101

Line 324: FROM gl_ledgers led

320: , fnd_global.USER_ID
321: , SYSDATE
322: , fnd_global.USER_ID
323: , fnd_global.LOGIN_ID
324: FROM gl_ledgers led
325: , gl_periods gp
326: WHERE led.ledger_id=p_ledger_id
327: AND led.period_set_name = gp.period_set_name
328: AND gp.period_name = p_period_name;

Line 342: FROM gl_ledgers led

338: , decode(gp.period_num,1,'Y','N')
339: INTO l_period_year
340: , l_period_num
341: , l_first_fiscal_period_flag
342: FROM gl_ledgers led
343: , gl_periods gp
344: WHERE led.ledger_id=p_ledger_id
345: AND led.period_set_name = gp.period_set_name
346: AND gp.period_name = p_period_name;

Line 530: FROM gl_ledgers sob

526: SELECT sob.RET_EARN_CODE_COMBINATION_ID
527: , sob.currency_code
528: INTO l_RET_EARN_CODE_COMBINATION_ID
529: , l_ret_currence_code
530: FROM gl_ledgers sob
531: WHERE sob.ledger_id = p_ledger_id;
532:
533: SELECT COUNT(*)
534: INTO l_row_count

Line 536: , gl_ledgers sob

532:
533: SELECT COUNT(*)
534: INTO l_row_count
535: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav
536: , gl_ledgers sob
537: , Fnd_Id_Flex_Segments ifs
538: WHERE sav.ID_FLEX_CODE = 'GL#'
539: AND sav.APPLICATION_ID = 101
540: AND sav.attribute_value = 'Y'

Line 593: FROM gl_ledgers sob

589: , l_ret_acct_balance_cr
590: , l_ret_acct_balance_dr_beq
591: , l_ret_acct_balance_cr_beq
592: , l_ret_currence_code
593: FROM gl_ledgers sob
594: , gl_balances gb
595: WHERE sob.ledger_id = p_ledger_id
596: AND sob.ret_earn_code_combination_id = gb.code_combination_id
597: AND gb.ledger_id = p_ledger_id

Line 1326: l_RET_EARN_CODE_COMBINATION_ID gl_ledgers.ret_earn_code_combination_id%TYPE;

1322: l_procedure_name VARCHAR2(30):='update_retained_account';
1323: l_period_year ja_cn_periods.period_year%TYPE;
1324: --l_period_name ja_cn_periods.period_name%TYPE;
1325:
1326: l_RET_EARN_CODE_COMBINATION_ID gl_ledgers.ret_earn_code_combination_id%TYPE;
1327: l_ret_currence_code ja_cn_account_balances.currency_code%TYPE;
1328: l_row_count NUMBER;
1329: l_cost_center_second_tracking BOOLEAN:=FALSE;
1330: l_period_num ja_cn_periods.period_num%TYPE;

Line 1352: FROM gl_ledgers led

1348: SELECT led.RET_EARN_CODE_COMBINATION_ID
1349: , led.currency_code
1350: INTO l_RET_EARN_CODE_COMBINATION_ID
1351: , l_ret_currence_code
1352: FROM gl_ledgers led
1353: WHERE led.ledger_id = p_ledger_id;
1354:
1355: --Get retained account, added for bug 9582957
1356: SELECT DISTINCT Account_Segment

Line 1364: , gl_ledgers led

1360:
1361: SELECT COUNT(*)
1362: INTO l_row_count
1363: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav
1364: , gl_ledgers led
1365: , Fnd_Id_Flex_Segments ifs
1366: WHERE sav.ID_FLEX_CODE = 'GL#'
1367: AND sav.APPLICATION_ID = 101
1368: AND sav.attribute_value = 'Y'

Line 1398: , gl_ledgers led

1394:
1395: SELECT ifs.flex_value_set_id
1396: INTO l_flex_value_set_id
1397: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav
1398: , gl_ledgers led
1399: , Fnd_Id_Flex_Segments ifs
1400: WHERE sav.SEGMENT_ATTRIBUTE_TYPE = 'GL_ACCOUNT'
1401: AND sav.ID_FLEX_CODE = 'GL#'
1402: AND sav.APPLICATION_ID = 101

Line 2856: , gl_ledgers led

2852: ,pc_num IN NUMBER) IS
2853: SELECT DISTINCT gp.period_name,gp.period_year,gp.period_num
2854: FROM /*JA_CN_JOURNAL_LINES jjl
2855: , */gl_periods gp
2856: , gl_ledgers led
2857: WHERE /*jjl.ledger_id = p_ledger_id
2858: AND jjl.legal_entity_id = p_legal_entity_ID
2859: AND jjl.status = 'U'
2860: AND */led.ledger_id = p_ledger_id

Line 3015: , gl_ledgers led

3011: , gp.period_num
3012: INTO l_period_year
3013: , l_period_num
3014: FROM gl_periods gp
3015: , gl_ledgers led
3016: WHERE gp.period_name=p_period_name
3017: AND gp.period_set_name=led.period_set_name
3018: AND led.ledger_id=p_ledger_id;
3019:

Line 3033: , gl_ledgers led

3029: --get the flexfield set ID for chart of account
3030: SELECT ifs.flex_value_set_id
3031: INTO l_flex_value_set_id
3032: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav
3033: , gl_ledgers led
3034: , Fnd_Id_Flex_Segments ifs
3035: WHERE sav.SEGMENT_ATTRIBUTE_TYPE = 'GL_ACCOUNT'
3036: AND sav.ID_FLEX_CODE = 'GL#'
3037: AND sav.APPLICATION_ID = 101