APPS.FV_YE_CLOSE dependencies on FV_YE_SEQUENCE_ACCOUNTS

Line 54: vg_acct_flag Fv_Ye_Sequence_Accounts.account_flag%TYPE;

50: vg_group_id Fv_Ye_Groups.group_id%TYPE;
51: vg_seq_id Fv_Ye_Group_Sequences.sequence_id%TYPE;
52: vg_seq Fv_Ye_Group_Sequences.SEQUENCE%TYPE;
53: vp_closing_method Fv_Ye_Groups.closing_method%TYPE ;
54: vg_acct_flag Fv_Ye_Sequence_Accounts.account_flag%TYPE;
55: vg_from_acct Fv_Ye_Sequence_Accounts.from_account%TYPE;
56: vg_child_acct Fv_Ye_Sequence_Accounts.from_account%TYPE;
57: vg_to_acct Fv_Ye_Sequence_Accounts.to_account%TYPE;
58: vg_requisition Fv_Ye_Sequence_Accounts.requisition%TYPE;

Line 55: vg_from_acct Fv_Ye_Sequence_Accounts.from_account%TYPE;

51: vg_seq_id Fv_Ye_Group_Sequences.sequence_id%TYPE;
52: vg_seq Fv_Ye_Group_Sequences.SEQUENCE%TYPE;
53: vp_closing_method Fv_Ye_Groups.closing_method%TYPE ;
54: vg_acct_flag Fv_Ye_Sequence_Accounts.account_flag%TYPE;
55: vg_from_acct Fv_Ye_Sequence_Accounts.from_account%TYPE;
56: vg_child_acct Fv_Ye_Sequence_Accounts.from_account%TYPE;
57: vg_to_acct Fv_Ye_Sequence_Accounts.to_account%TYPE;
58: vg_requisition Fv_Ye_Sequence_Accounts.requisition%TYPE;
59: vg_closing_method fv_ye_groups.closing_method%TYPE;

Line 56: vg_child_acct Fv_Ye_Sequence_Accounts.from_account%TYPE;

52: vg_seq Fv_Ye_Group_Sequences.SEQUENCE%TYPE;
53: vp_closing_method Fv_Ye_Groups.closing_method%TYPE ;
54: vg_acct_flag Fv_Ye_Sequence_Accounts.account_flag%TYPE;
55: vg_from_acct Fv_Ye_Sequence_Accounts.from_account%TYPE;
56: vg_child_acct Fv_Ye_Sequence_Accounts.from_account%TYPE;
57: vg_to_acct Fv_Ye_Sequence_Accounts.to_account%TYPE;
58: vg_requisition Fv_Ye_Sequence_Accounts.requisition%TYPE;
59: vg_closing_method fv_ye_groups.closing_method%TYPE;
60: -- Bug 10399298

Line 57: vg_to_acct Fv_Ye_Sequence_Accounts.to_account%TYPE;

53: vp_closing_method Fv_Ye_Groups.closing_method%TYPE ;
54: vg_acct_flag Fv_Ye_Sequence_Accounts.account_flag%TYPE;
55: vg_from_acct Fv_Ye_Sequence_Accounts.from_account%TYPE;
56: vg_child_acct Fv_Ye_Sequence_Accounts.from_account%TYPE;
57: vg_to_acct Fv_Ye_Sequence_Accounts.to_account%TYPE;
58: vg_requisition Fv_Ye_Sequence_Accounts.requisition%TYPE;
59: vg_closing_method fv_ye_groups.closing_method%TYPE;
60: -- Bug 10399298
61: treasury_closing_method fv_fund_parameters.close_requisitions%TYPE;

Line 58: vg_requisition Fv_Ye_Sequence_Accounts.requisition%TYPE;

54: vg_acct_flag Fv_Ye_Sequence_Accounts.account_flag%TYPE;
55: vg_from_acct Fv_Ye_Sequence_Accounts.from_account%TYPE;
56: vg_child_acct Fv_Ye_Sequence_Accounts.from_account%TYPE;
57: vg_to_acct Fv_Ye_Sequence_Accounts.to_account%TYPE;
58: vg_requisition Fv_Ye_Sequence_Accounts.requisition%TYPE;
59: vg_closing_method fv_ye_groups.closing_method%TYPE;
60: -- Bug 10399298
61: treasury_closing_method fv_fund_parameters.close_requisitions%TYPE;
62: vg_balance_read_flag Fv_Ye_Seq_Bal_Temp.balance_read_flag%TYPE;

Line 704: FROM Fv_Ye_Sequence_Accounts

700: -- ------------------------------------------------------------------
701: PROCEDURE Chk_To_Accounts IS
702: CURSOR get_toaccts_cur IS
703: SELECT DISTINCT to_account
704: FROM Fv_Ye_Sequence_Accounts
705: WHERE set_of_books_id = vg_sob_id
706: ORDER BY to_account;
707:
708: vl_parent_flag VARCHAR2(1) ;

Line 1477: FROM Fv_Ye_Sequence_Accounts

1473: ORDER BY SEQUENCE;
1474:
1475: CURSOR get_acct_cur IS
1476: SELECT from_account,to_account, requisition
1477: FROM Fv_Ye_Sequence_Accounts
1478: WHERE sequence_id = vg_seq_id
1479: AND account_flag = vg_acct_flag
1480: AND set_of_books_id = vg_sob_id
1481: ORDER BY order_by_ctr;

Line 1485: FROM Fv_Ye_Sequence_Accounts

1481: ORDER BY order_by_ctr;
1482:
1483: CURSOR get_count_cur IS
1484: SELECT COUNT(*)
1485: FROM Fv_Ye_Sequence_Accounts
1486: WHERE sequence_id = vg_seq_id
1487: AND set_of_books_id = vg_sob_id;
1488:
1489: vl_seqrec_flag VARCHAR2(1) ;

Line 2274: vl_acct Fv_Ye_Sequence_Accounts.from_account%TYPE;

2270: PROCEDURE Determine_DrCr(ccid NUMBER) IS
2271: vl_dbt_flag VARCHAR2(1);
2272: vl_crt_flag VARCHAR2(1);
2273:
2274: vl_acct Fv_Ye_Sequence_Accounts.from_account%TYPE;
2275: vl_remaining_bal NUMBER;
2276: vl_drcr_flag VARCHAR2(1);
2277: vl_read_flag VARCHAR2(1);
2278: vl_ccid Gl_Code_Combinations.code_combination_id%TYPE;