APPS.FV_REIMB_ACTIVITY_PROCESS dependencies on FV_REIMB_DEFINITIONS_LINES

Line 141: FROM Fv_reimb_definitions_lines

137: -- Check whether set up done
138: -- Check if Seed process was run
139:
140: SELECT COUNT(1) INTO l_seed_count
141: FROM Fv_reimb_definitions_lines
142: WHERE set_of_books_id = g_ledger_id;
143:
144: IF l_seed_count=0 THEN
145: g_retcode := -1 ;

Line 154: FROM Fv_reimb_definitions_lines fvrd ,

150: -- Check whether Accounts are Defined in the form ,
151: -- Reimbursable Activity Report Definitions .
152:
153: SELECT COUNT(1) INTO l_Acct_count
154: FROM Fv_reimb_definitions_lines fvrd ,
155: Fv_reimb_def_Acct_assign fvda
156: WHERE fvrd.column_id=fvda.column_id
157: AND fvrd.set_of_books_id = g_ledger_id;
158:

Line 805: FROM fv_reimb_definitions_lines

801: -- Bug 8992292
802: --Added condition to check set_of_books_id to avoid multiple rows
803: SELECT rec_sla_detail, natural_balance_type
804: INTO l_rec_sla_detail, l_natural_balance_type
805: FROM fv_reimb_definitions_lines
806: WHERE column_id = l_column_id and set_of_books_id=g_ledger_id;
807: EXCEPTION
808: WHEN NO_DATA_FOUND then
809: g_retcode := SQLCODE;

Line 1541: fv_reimb_definitions_lines frd,

1537:
1538: l_glbal_sql := 'SELECT '||g_select||' , '||l_bal_amount_sql||'
1539: FROM gl_balances glb,
1540: gl_code_combinations_kfv glcc,
1541: fv_reimb_definitions_lines frd,
1542: fv_reimb_def_acct_assign fva
1543: WHERE
1544: frd.column_id = fva.column_id
1545: and glb.actual_flag =''A''

Line 1575: fv_reimb_definitions_lines frd,

1571:
1572: l_glbc_sql:= 'SELECT '||g_select||' , '||l_bc_amount_sql||'
1573: FROM gl_bc_packets glbc,
1574: gl_code_combinations_kfv glcc,
1575: fv_reimb_definitions_lines frd,
1576: fv_reimb_def_acct_assign fva
1577: WHERE
1578: frd.column_id = fva.column_id
1579: and glbc.actual_flag =''A''

Line 1647: fv_reimb_definitions_lines frd,

1643:
1644: l_main_sql :=
1645: 'SELECT '||g_select||' , '||l_sla_amount_sql||'
1646: FROM gl_code_combinations_kfv glcc,
1647: fv_reimb_definitions_lines frd,
1648: fv_reimb_def_acct_assign fva,
1649: xla_ae_headers xah,
1650: xla_ae_lines xal
1651: WHERE