APPS.FV_YE_CLOSE dependencies on FV_YE_SEQUENCE_ACCOUNTS

Line 50: vg_acct_flag Fv_Ye_Sequence_Accounts.account_flag%TYPE;

46: vg_fund_value Fv_Fund_Parameters.fund_value%TYPE;
47: vg_group_id Fv_Ye_Groups.group_id%TYPE;
48: vg_seq_id Fv_Ye_Group_Sequences.sequence_id%TYPE;
49: vg_seq Fv_Ye_Group_Sequences.SEQUENCE%TYPE;
50: vg_acct_flag Fv_Ye_Sequence_Accounts.account_flag%TYPE;
51: vg_from_acct Fv_Ye_Sequence_Accounts.from_account%TYPE;
52: vg_child_acct Fv_Ye_Sequence_Accounts.from_account%TYPE;
53: vg_to_acct Fv_Ye_Sequence_Accounts.to_account%TYPE;
54: vg_balance_read_flag Fv_Ye_Seq_Bal_Temp.balance_read_flag%TYPE;

Line 51: vg_from_acct Fv_Ye_Sequence_Accounts.from_account%TYPE;

47: vg_group_id Fv_Ye_Groups.group_id%TYPE;
48: vg_seq_id Fv_Ye_Group_Sequences.sequence_id%TYPE;
49: vg_seq Fv_Ye_Group_Sequences.SEQUENCE%TYPE;
50: vg_acct_flag Fv_Ye_Sequence_Accounts.account_flag%TYPE;
51: vg_from_acct Fv_Ye_Sequence_Accounts.from_account%TYPE;
52: vg_child_acct Fv_Ye_Sequence_Accounts.from_account%TYPE;
53: vg_to_acct Fv_Ye_Sequence_Accounts.to_account%TYPE;
54: vg_balance_read_flag Fv_Ye_Seq_Bal_Temp.balance_read_flag%TYPE;
55: vg_bal_seq_amt NUMBER;

Line 52: vg_child_acct Fv_Ye_Sequence_Accounts.from_account%TYPE;

48: vg_seq_id Fv_Ye_Group_Sequences.sequence_id%TYPE;
49: vg_seq Fv_Ye_Group_Sequences.SEQUENCE%TYPE;
50: vg_acct_flag Fv_Ye_Sequence_Accounts.account_flag%TYPE;
51: vg_from_acct Fv_Ye_Sequence_Accounts.from_account%TYPE;
52: vg_child_acct Fv_Ye_Sequence_Accounts.from_account%TYPE;
53: vg_to_acct Fv_Ye_Sequence_Accounts.to_account%TYPE;
54: vg_balance_read_flag Fv_Ye_Seq_Bal_Temp.balance_read_flag%TYPE;
55: vg_bal_seq_amt NUMBER;
56: vg_gl_bal_amt NUMBER;

Line 53: vg_to_acct Fv_Ye_Sequence_Accounts.to_account%TYPE;

49: vg_seq Fv_Ye_Group_Sequences.SEQUENCE%TYPE;
50: vg_acct_flag Fv_Ye_Sequence_Accounts.account_flag%TYPE;
51: vg_from_acct Fv_Ye_Sequence_Accounts.from_account%TYPE;
52: vg_child_acct Fv_Ye_Sequence_Accounts.from_account%TYPE;
53: vg_to_acct Fv_Ye_Sequence_Accounts.to_account%TYPE;
54: vg_balance_read_flag Fv_Ye_Seq_Bal_Temp.balance_read_flag%TYPE;
55: vg_bal_seq_amt NUMBER;
56: vg_gl_bal_amt NUMBER;
57: vg_coy_dr NUMBER;

Line 711: FROM Fv_Ye_Sequence_Accounts

707: -- ------------------------------------------------------------------
708: PROCEDURE Chk_To_Accounts IS
709: CURSOR get_toaccts_cur IS
710: SELECT DISTINCT to_account
711: FROM Fv_Ye_Sequence_Accounts
712: WHERE set_of_books_id = vg_sob_id
713: ORDER BY to_account;
714:
715: vl_parent_flag VARCHAR2(1) ;

Line 1461: FROM Fv_Ye_Sequence_Accounts

1457: ORDER BY SEQUENCE;
1458:
1459: CURSOR get_acct_cur IS
1460: SELECT from_account,to_account
1461: FROM Fv_Ye_Sequence_Accounts
1462: WHERE sequence_id = vg_seq_id
1463: AND account_flag = vg_acct_flag
1464: AND set_of_books_id = vg_sob_id
1465: ORDER BY order_by_ctr;

Line 1469: FROM Fv_Ye_Sequence_Accounts

1465: ORDER BY order_by_ctr;
1466:
1467: CURSOR get_count_cur IS
1468: SELECT COUNT(*)
1469: FROM Fv_Ye_Sequence_Accounts
1470: WHERE sequence_id = vg_seq_id
1471: AND set_of_books_id = vg_sob_id;
1472:
1473: vl_seqrec_flag VARCHAR2(1) ;

Line 2225: vl_acct Fv_Ye_Sequence_Accounts.from_account%TYPE;

2221: PROCEDURE Determine_DrCr(ccid NUMBER) IS
2222: vl_dbt_flag VARCHAR2(1);
2223: vl_crt_flag VARCHAR2(1);
2224:
2225: vl_acct Fv_Ye_Sequence_Accounts.from_account%TYPE;
2226: vl_remaining_bal NUMBER;
2227: vl_drcr_flag VARCHAR2(1);
2228: vl_read_flag VARCHAR2(1);
2229: vl_ccid Gl_Code_Combinations.code_combination_id%TYPE;