DBA Data[Home] [Help]

APPS.GL_AUTO_ALLOC_WF_PKG dependencies on GL_JE_HEADERS

Line 1657: FROM gl_je_headers

1653: END IF;
1654: -- Delete all of the lines in that batch
1655: DELETE gl_je_lines
1656: WHERE je_header_id IN (SELECT je_header_id
1657: FROM gl_je_headers
1658: WHERE je_batch_id = l_gen_batch_Id);
1659:
1660: -- Delete all of the headers in that batch
1661: DELETE gl_je_headers

Line 1661: DELETE gl_je_headers

1657: FROM gl_je_headers
1658: WHERE je_batch_id = l_gen_batch_Id);
1659:
1660: -- Delete all of the headers in that batch
1661: DELETE gl_je_headers
1662: WHERE je_batch_id = l_gen_batch_Id;
1663:
1664: -- Delete gl_je_batch
1665: DELETE gl_je_batches

Line 1728: FROM GL_JE_HEADERS JE

1724: Order by STEP_NUMBER desc;
1725:
1726: Cursor Get_Headers_C IS
1727: Select JE.JE_HEADER_ID
1728: FROM GL_JE_HEADERS JE
1729: WHERE JE.JE_BATCH_ID = l_gen_batch_id
1730: AND NOT EXISTS ( SELECT RB.JE_HEADER_ID
1731: FROM GL_AUTO_ALLOC_REV_BATCHES RB
1732: WHERE RB.PARENT_REQUEST_ID = to_number(p_item_key)

Line 1998: From GL_JE_HEADERS

1994: Cursor verify_reversal_C IS
1995: Select
1996: Accrual_rev_status
1997: ,Accrual_rev_je_header_id
1998: From GL_JE_HEADERS
1999: Where JE_HEADER_ID = l_je_header_id;
2000:
2001: Begin
2002: If ( p_funcmode = 'RUN' ) THEN

Line 2702: FROM GL_JE_HEADERS JEH,

2698: SELECT 'untaxed journals'
2699: FROM DUAL
2700: WHERE EXISTS
2701: (SELECT 'UNTAXED'
2702: FROM GL_JE_HEADERS JEH,
2703: GL_LEDGERS LGR
2704: WHERE JEH.je_batch_id = l_je_batch_id
2705: AND JEH.tax_status_code = 'R'
2706: AND JEH.currency_code <> 'STAT'

Line 2732: FROM GL_JE_HEADERS jh, GL_LEDGERS lgr

2728: SELECT
2729: jh.LEDGER_ID,
2730: jh.BUDGET_VERSION_ID,
2731: lgr.LATEST_ENCUMBRANCE_YEAR
2732: FROM GL_JE_HEADERS jh, GL_LEDGERS lgr
2733: WHERE jh.JE_BATCH_ID = l_je_batch_id
2734: AND lgr.LEDGER_ID = jh.LEDGER_ID
2735: AND lgr.LEDGER_CATEGORY_CODE <> 'NONE';
2736:

Line 3109: Update GL_JE_HEADERS

3105: IF (diagn_debug_msg_flag) AND (G_DIR is NOT NULL ) THEN
3106: diagn_debug_msg('SUBMIT_REV_PROGRAM: ' || 'Updating accrual_rev_period_name = '||l_period_name);
3107: END IF;
3108:
3109: Update GL_JE_HEADERS
3110: Set accrual_rev_flag = 'Y'
3111: , accrual_rev_period_name = l_period_name
3112: , accrual_rev_effective_date = decode(actual_flag,'A',
3113: default_effective_date,accrual_rev_effective_date)