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.FUN_RECIPIENT_WF dependencies on GL_LEDGER_LE_BSV_SPECIFIC_V

Line 2690: FROM gl_ledger_le_bsv_specific_v vals

2686: CURSOR c_get_bsv(p_ledger_id NUMBER,
2687: p_le_id NUMBER,
2688: p_gl_date DATE) IS
2689: SELECT vals.segment_value
2690: FROM gl_ledger_le_bsv_specific_v vals
2691: WHERE vals.legal_entity_id = p_le_id
2692: AND vals.ledger_id = p_ledger_id
2693: AND p_gl_date BETWEEN Nvl(vals.start_date, p_gl_date) AND Nvl(vals.end_date, p_gl_date)
2694: AND (SELECT COUNT(*)

Line 2695: FROM gl_ledger_le_bsv_specific_v vals1

2691: WHERE vals.legal_entity_id = p_le_id
2692: AND vals.ledger_id = p_ledger_id
2693: AND p_gl_date BETWEEN Nvl(vals.start_date, p_gl_date) AND Nvl(vals.end_date, p_gl_date)
2694: AND (SELECT COUNT(*)
2695: FROM gl_ledger_le_bsv_specific_v vals1
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:

Line 2702: l_initiator_bsv gl_ledger_le_bsv_specific_v.segment_value%TYPE;

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;
2706: l_reci_bsv gl_ledger_le_bsv_specific_v.segment_value%TYPE;

Line 2703: l_recipient_bsv gl_ledger_le_bsv_specific_v.segment_value%TYPE;

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;
2706: l_reci_bsv gl_ledger_le_bsv_specific_v.segment_value%TYPE;
2707:

Line 2705: l_init_bsv gl_ledger_le_bsv_specific_v.segment_value%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;
2706: l_reci_bsv gl_ledger_le_bsv_specific_v.segment_value%TYPE;
2707:
2708:
2709: TYPE dist_line_tbl_type IS TABLE OF dist_line_rec_type

Line 2706: l_reci_bsv gl_ledger_le_bsv_specific_v.segment_value%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;
2706: l_reci_bsv gl_ledger_le_bsv_specific_v.segment_value%TYPE;
2707:
2708:
2709: TYPE dist_line_tbl_type IS TABLE OF dist_line_rec_type
2710: INDEX BY BINARY_INTEGER;

Line 3928: FROM gl_ledger_le_bsv_specific_v vals

3924: CURSOR c_get_bsv(p_ledger_id NUMBER,
3925: p_le_id NUMBER,
3926: p_gl_date DATE) IS
3927: SELECT vals.segment_value
3928: FROM gl_ledger_le_bsv_specific_v vals
3929: WHERE vals.legal_entity_id = p_le_id
3930: AND vals.ledger_id = p_ledger_id
3931: AND p_gl_date BETWEEN Nvl(vals.start_date, p_gl_date) AND Nvl(vals.end_date, p_gl_date)
3932: AND (SELECT COUNT(*)

Line 3933: FROM gl_ledger_le_bsv_specific_v vals1

3929: WHERE vals.legal_entity_id = p_le_id
3930: AND vals.ledger_id = p_ledger_id
3931: AND p_gl_date BETWEEN Nvl(vals.start_date, p_gl_date) AND Nvl(vals.end_date, p_gl_date)
3932: AND (SELECT COUNT(*)
3933: FROM gl_ledger_le_bsv_specific_v vals1
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:

Line 3940: l_initiator_bsv gl_ledger_le_bsv_specific_v.segment_value%TYPE;

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:
3944: BEGIN

Line 3941: l_recipient_bsv gl_ledger_le_bsv_specific_v.segment_value%TYPE;

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:
3944: BEGIN
3945: x_status := FND_API.G_RET_STS_SUCCESS;