DBA Data[Home] [Help]

APPS.JA_CN_POST_UTILITY_PKG dependencies on JA_CN_JOURNAL_LINES

Line 2854: FROM /*JA_CN_JOURNAL_LINES jjl

2850:
2851: CURSOR c_periods(pc_year IN NUMBER
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

Line 2921: FROM JA_CN_JOURNAL_LINES jjl

2917: , jjl.segment29
2918: , jjl.segment30
2919: , jjl.ACCOUNT_SEGMENT
2920: , jjl.period_name
2921: FROM JA_CN_JOURNAL_LINES jjl
2922: , FND_FLEX_VALUES ffv
2923: WHERE jjl.ledger_id = p_ledger_id
2924: AND jjl.legal_entity_id = p_legal_entity_ID
2925: AND jjl.status = 'U'

Line 3193: UPDATE ja_cn_journal_lines jl

3189:
3190: END LOOP;
3191:
3192: --update the journal status
3193: UPDATE ja_cn_journal_lines jl
3194: SET jl.status='P'
3195: WHERE jl.ledger_id = p_ledger_id
3196: AND jl.LEGAL_ENTITY_ID = p_legal_entity_ID
3197: AND jl.PERIOD_NAME = rec_period.period_name