DBA Data[Home] [Help]

APPS.FUN_RECIPIENT_WF dependencies on FUN_TRX_ACCT_DEFINITIONS

Line 2683: FROM fun_trx_acct_definitions

2679:
2680: CURSOR c_chk_sla (p_ledger_id IN NUMBER) IS
2681: SELECT amb_context_code,
2682: account_definition_code
2683: FROM fun_trx_acct_definitions
2684: WHERE ledger_id = p_ledger_id;
2685:
2686: CURSOR c_get_bsv(p_ledger_id NUMBER,
2687: p_le_id NUMBER,

Line 2700: l_amb_context_code fun_trx_acct_definitions.amb_context_code%TYPE;

2696: WHERE vals1.legal_entity_id = p_le_id
2697: AND vals1.ledger_id = p_ledger_id
2698: AND p_gl_date BETWEEN Nvl(vals1.start_date, p_gl_date) AND Nvl(vals1.end_date, p_gl_date)) = 1;
2699:
2700: l_amb_context_code fun_trx_acct_definitions.amb_context_code%TYPE;
2701: l_account_definition_code fun_trx_acct_definitions.account_definition_code%TYPE;
2702: l_initiator_bsv gl_ledger_le_bsv_specific_v.segment_value%TYPE;
2703: l_recipient_bsv gl_ledger_le_bsv_specific_v.segment_value%TYPE;
2704: -- Added for bug # 7520196

Line 2701: l_account_definition_code fun_trx_acct_definitions.account_definition_code%TYPE;

2697: AND vals1.ledger_id = p_ledger_id
2698: AND p_gl_date BETWEEN Nvl(vals1.start_date, p_gl_date) AND Nvl(vals1.end_date, p_gl_date)) = 1;
2699:
2700: l_amb_context_code fun_trx_acct_definitions.amb_context_code%TYPE;
2701: l_account_definition_code fun_trx_acct_definitions.account_definition_code%TYPE;
2702: l_initiator_bsv gl_ledger_le_bsv_specific_v.segment_value%TYPE;
2703: l_recipient_bsv gl_ledger_le_bsv_specific_v.segment_value%TYPE;
2704: -- Added for bug # 7520196
2705: l_init_bsv gl_ledger_le_bsv_specific_v.segment_value%TYPE;

Line 3921: FROM fun_trx_acct_definitions

3917:
3918: CURSOR c_chk_sla (p_ledger_id IN NUMBER) IS
3919: SELECT amb_context_code,
3920: account_definition_code
3921: FROM fun_trx_acct_definitions
3922: WHERE ledger_id = p_ledger_id;
3923:
3924: CURSOR c_get_bsv(p_ledger_id NUMBER,
3925: p_le_id NUMBER,

Line 3938: l_amb_context_code fun_trx_acct_definitions.amb_context_code%TYPE;

3934: WHERE vals1.legal_entity_id = p_le_id
3935: AND vals1.ledger_id = p_ledger_id
3936: AND p_gl_date BETWEEN Nvl(vals1.start_date, p_gl_date) AND Nvl(vals1.end_date, p_gl_date)) = 1;
3937:
3938: l_amb_context_code fun_trx_acct_definitions.amb_context_code%TYPE;
3939: l_account_definition_code fun_trx_acct_definitions.account_definition_code%TYPE;
3940: l_initiator_bsv gl_ledger_le_bsv_specific_v.segment_value%TYPE;
3941: l_recipient_bsv gl_ledger_le_bsv_specific_v.segment_value%TYPE;
3942: l_init_ccid fun_dist_lines.ccid%TYPE;

Line 3939: l_account_definition_code fun_trx_acct_definitions.account_definition_code%TYPE;

3935: AND vals1.ledger_id = p_ledger_id
3936: AND p_gl_date BETWEEN Nvl(vals1.start_date, p_gl_date) AND Nvl(vals1.end_date, p_gl_date)) = 1;
3937:
3938: l_amb_context_code fun_trx_acct_definitions.amb_context_code%TYPE;
3939: l_account_definition_code fun_trx_acct_definitions.account_definition_code%TYPE;
3940: l_initiator_bsv gl_ledger_le_bsv_specific_v.segment_value%TYPE;
3941: l_recipient_bsv gl_ledger_le_bsv_specific_v.segment_value%TYPE;
3942: l_init_ccid fun_dist_lines.ccid%TYPE;
3943: