DBA Data[Home] [Help]

APPS.FUN_RECIPIENT_WF dependencies on FUN_TRX_ACCT_DEFINITIONS

Line 2452: FROM fun_trx_acct_definitions

2448:
2449: CURSOR c_chk_sla (p_ledger_id IN NUMBER) IS
2450: SELECT amb_context_code,
2451: account_definition_code
2452: FROM fun_trx_acct_definitions
2453: WHERE ledger_id = p_ledger_id;
2454:
2455: CURSOR c_get_bsv(p_ledger_id NUMBER,
2456: p_le_id NUMBER,

Line 2469: l_amb_context_code fun_trx_acct_definitions.amb_context_code%TYPE;

2465: WHERE vals1.legal_entity_id = p_le_id
2466: AND vals1.ledger_id = p_ledger_id
2467: AND p_gl_date BETWEEN Nvl(vals1.start_date, p_gl_date) AND Nvl(vals1.end_date, p_gl_date)) = 1;
2468:
2469: l_amb_context_code fun_trx_acct_definitions.amb_context_code%TYPE;
2470: l_account_definition_code fun_trx_acct_definitions.account_definition_code%TYPE;
2471: l_initiator_bsv gl_ledger_le_bsv_specific_v.segment_value%TYPE;
2472: l_recipient_bsv gl_ledger_le_bsv_specific_v.segment_value%TYPE;
2473: -- Added for bug # 7520196

Line 2470: l_account_definition_code fun_trx_acct_definitions.account_definition_code%TYPE;

2466: AND vals1.ledger_id = p_ledger_id
2467: AND p_gl_date BETWEEN Nvl(vals1.start_date, p_gl_date) AND Nvl(vals1.end_date, p_gl_date)) = 1;
2468:
2469: l_amb_context_code fun_trx_acct_definitions.amb_context_code%TYPE;
2470: l_account_definition_code fun_trx_acct_definitions.account_definition_code%TYPE;
2471: l_initiator_bsv gl_ledger_le_bsv_specific_v.segment_value%TYPE;
2472: l_recipient_bsv gl_ledger_le_bsv_specific_v.segment_value%TYPE;
2473: -- Added for bug # 7520196
2474: l_init_bsv gl_ledger_le_bsv_specific_v.segment_value%TYPE;

Line 3541: FROM fun_trx_acct_definitions

3537:
3538: CURSOR c_chk_sla (p_ledger_id IN NUMBER) IS
3539: SELECT amb_context_code,
3540: account_definition_code
3541: FROM fun_trx_acct_definitions
3542: WHERE ledger_id = p_ledger_id;
3543:
3544: CURSOR c_get_bsv(p_ledger_id NUMBER,
3545: p_le_id NUMBER,

Line 3558: l_amb_context_code fun_trx_acct_definitions.amb_context_code%TYPE;

3554: WHERE vals1.legal_entity_id = p_le_id
3555: AND vals1.ledger_id = p_ledger_id
3556: AND p_gl_date BETWEEN Nvl(vals1.start_date, p_gl_date) AND Nvl(vals1.end_date, p_gl_date)) = 1;
3557:
3558: l_amb_context_code fun_trx_acct_definitions.amb_context_code%TYPE;
3559: l_account_definition_code fun_trx_acct_definitions.account_definition_code%TYPE;
3560: l_initiator_bsv gl_ledger_le_bsv_specific_v.segment_value%TYPE;
3561: l_recipient_bsv gl_ledger_le_bsv_specific_v.segment_value%TYPE;
3562:

Line 3559: l_account_definition_code fun_trx_acct_definitions.account_definition_code%TYPE;

3555: AND vals1.ledger_id = p_ledger_id
3556: AND p_gl_date BETWEEN Nvl(vals1.start_date, p_gl_date) AND Nvl(vals1.end_date, p_gl_date)) = 1;
3557:
3558: l_amb_context_code fun_trx_acct_definitions.amb_context_code%TYPE;
3559: l_account_definition_code fun_trx_acct_definitions.account_definition_code%TYPE;
3560: l_initiator_bsv gl_ledger_le_bsv_specific_v.segment_value%TYPE;
3561: l_recipient_bsv gl_ledger_le_bsv_specific_v.segment_value%TYPE;
3562:
3563: BEGIN