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 154: /*l_RET_EARN_CODE_COMBINATION_ID gl_ledgers.ret_earn_code_combination_id%TYPE;

150: l_prior_period_name gl_periods.period_name%TYPE;
151: l_prior_period_num ja_cn_periods.period_num%TYPE;
152:
153: l_period_month ja_cn_account_balances.period_mon%TYPE;
154: /*l_RET_EARN_CODE_COMBINATION_ID gl_ledgers.ret_earn_code_combination_id%TYPE;
155:
156: l_ret_company_segment ja_cn_account_balances.company_segment%TYPE;
157: l_ret_cost_center_seg ja_cn_account_balances.cost_center%TYPE;
158: l_ret_account_segment ja_cn_account_balances.account_segment%TYPE;

Line 231: , gl_ledgers led

227:
228: SELECT ifs.flex_value_set_id
229: INTO l_flex_value_set_id
230: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav
231: , gl_ledgers led
232: , Fnd_Id_Flex_Segments ifs
233: WHERE sav.SEGMENT_ATTRIBUTE_TYPE = 'GL_ACCOUNT'
234: AND sav.ID_FLEX_CODE = 'GL#'
235: AND sav.APPLICATION_ID = 101

Line 287: FROM gl_ledgers led

283: , fnd_global.USER_ID
284: , SYSDATE
285: , fnd_global.USER_ID
286: , fnd_global.LOGIN_ID
287: FROM gl_ledgers led
288: , gl_periods gp
289: WHERE led.ledger_id=p_ledger_id
290: AND led.period_set_name = gp.period_set_name
291: AND gp.period_name = p_period_name;

Line 305: FROM gl_ledgers led

301: , decode(gp.period_num,1,'Y','N')
302: INTO l_period_year
303: , l_period_num
304: , l_first_fiscal_period_flag
305: FROM gl_ledgers led
306: , gl_periods gp
307: WHERE led.ledger_id=p_ledger_id
308: AND led.period_set_name = gp.period_set_name
309: AND gp.period_name = p_period_name;

Line 433: FROM gl_ledgers sob

429: SELECT sob.RET_EARN_CODE_COMBINATION_ID
430: , sob.currency_code
431: INTO l_RET_EARN_CODE_COMBINATION_ID
432: , l_ret_currence_code
433: FROM gl_ledgers sob
434: WHERE sob.ledger_id = p_ledger_id;
435:
436: SELECT COUNT(*)
437: INTO l_row_count

Line 439: , gl_ledgers sob

435:
436: SELECT COUNT(*)
437: INTO l_row_count
438: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav
439: , gl_ledgers sob
440: , Fnd_Id_Flex_Segments ifs
441: WHERE sav.ID_FLEX_CODE = 'GL#'
442: AND sav.APPLICATION_ID = 101
443: AND sav.attribute_value = 'Y'

Line 496: FROM gl_ledgers sob

492: , l_ret_acct_balance_cr
493: , l_ret_acct_balance_dr_beq
494: , l_ret_acct_balance_cr_beq
495: , l_ret_currence_code
496: FROM gl_ledgers sob
497: , gl_balances gb
498: WHERE sob.ledger_id = p_ledger_id
499: AND sob.ret_earn_code_combination_id = gb.code_combination_id
500: AND gb.ledger_id = p_ledger_id

Line 978: l_RET_EARN_CODE_COMBINATION_ID gl_ledgers.ret_earn_code_combination_id%TYPE;

974: l_procedure_name VARCHAR2(30):='update_retained_account';
975: l_period_year ja_cn_periods.period_year%TYPE;
976: --l_period_name ja_cn_periods.period_name%TYPE;
977:
978: l_RET_EARN_CODE_COMBINATION_ID gl_ledgers.ret_earn_code_combination_id%TYPE;
979: l_ret_currence_code ja_cn_account_balances.currency_code%TYPE;
980: l_row_count NUMBER;
981: l_cost_center_second_tracking BOOLEAN:=FALSE;
982: l_period_num ja_cn_periods.period_num%TYPE;

Line 1004: FROM gl_ledgers led

1000: SELECT led.RET_EARN_CODE_COMBINATION_ID
1001: , led.currency_code
1002: INTO l_RET_EARN_CODE_COMBINATION_ID
1003: , l_ret_currence_code
1004: FROM gl_ledgers led
1005: WHERE led.ledger_id = p_ledger_id;
1006:
1007: SELECT COUNT(*)
1008: INTO l_row_count

Line 1010: , gl_ledgers led

1006:
1007: SELECT COUNT(*)
1008: INTO l_row_count
1009: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav
1010: , gl_ledgers led
1011: , Fnd_Id_Flex_Segments ifs
1012: WHERE sav.ID_FLEX_CODE = 'GL#'
1013: AND sav.APPLICATION_ID = 101
1014: AND sav.attribute_value = 'Y'

Line 1044: , gl_ledgers led

1040:
1041: SELECT ifs.flex_value_set_id
1042: INTO l_flex_value_set_id
1043: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav
1044: , gl_ledgers led
1045: , Fnd_Id_Flex_Segments ifs
1046: WHERE sav.SEGMENT_ATTRIBUTE_TYPE = 'GL_ACCOUNT'
1047: AND sav.ID_FLEX_CODE = 'GL#'
1048: AND sav.APPLICATION_ID = 101

Line 1805: , gl_ledgers led

1801: ,pc_num IN NUMBER) IS
1802: SELECT DISTINCT gp.period_name,gp.period_year,gp.period_num
1803: FROM /*JA_CN_JOURNAL_LINES jjl
1804: , */gl_periods gp
1805: , gl_ledgers led
1806: WHERE /*jjl.ledger_id = p_ledger_id
1807: AND jjl.legal_entity_id = p_legal_entity_ID
1808: AND jjl.status = 'U'
1809: AND */led.ledger_id = p_ledger_id

Line 1900: , gl_ledgers led

1896: , gp.period_num
1897: INTO l_period_year
1898: , l_period_num
1899: FROM gl_periods gp
1900: , gl_ledgers led
1901: WHERE gp.period_name=p_period_name
1902: AND gp.period_set_name=led.period_set_name
1903: AND led.ledger_id=p_ledger_id;
1904:

Line 1918: , gl_ledgers led

1914: --get the flexfield set ID for chart of account
1915: SELECT ifs.flex_value_set_id
1916: INTO l_flex_value_set_id
1917: FROM FND_SEGMENT_ATTRIBUTE_VALUES sav
1918: , gl_ledgers led
1919: , Fnd_Id_Flex_Segments ifs
1920: WHERE sav.SEGMENT_ATTRIBUTE_TYPE = 'GL_ACCOUNT'
1921: AND sav.ID_FLEX_CODE = 'GL#'
1922: AND sav.APPLICATION_ID = 101