APPS.FV_YE_CLOSE dependencies on FV_YE_GROUPS

Line 47: vg_group_id Fv_Ye_Groups.group_id%TYPE;

43: vg_bal_seg_val_opt_code gl_ledgers_public_v.bal_seg_value_option_code%TYPE;
44: vg_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
45: vg_trsymbol_id Fv_Treasury_Symbols.treasury_symbol_id%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;

Line 1053: -- fv_ye_groups table. And then calls the Get_Fund_Value procedure.

1049: -- ------------------------------------------------------------------
1050: -- Get_Year_End_Record procedure is called from
1051: -- Check_Year_End_Parameters procedure.
1052: -- It gets the treasury_symbol_id and then the group_id from
1053: -- fv_ye_groups table. And then calls the Get_Fund_Value procedure.
1054: -- ------------------------------------------------------------------
1055: PROCEDURE Get_Year_End_Record(trsymbol VARCHAR2,
1056: fundgroup VARCHAR2,
1057: timeframe VARCHAR2 ) IS

Line 1105: FROM Fv_Ye_Groups

1101: END IF;
1102:
1103: OPEN vc_groupid FOR
1104: 'SELECT group_id
1105: FROM Fv_Ye_Groups
1106: WHERE treasury_symbol_id = :trsymbol_id
1107: AND fund_group_code = :fundgroup
1108: AND fund_time_frame = :timeframe
1109: AND set_of_books_id = :sob_id'

Line 1127: FROM Fv_Ye_Groups

1123:
1124: -- Looking for group_id for timeframe and fundgroup parameters
1125: OPEN vc_groupid FOR
1126: 'SELECT group_id
1127: FROM Fv_Ye_Groups
1128: WHERE treasury_symbol_id IS NULL
1129: AND fund_group_code = :fundgroup
1130: AND fund_time_frame = :timeframe
1131: AND set_of_books_id = :sob_id'

Line 1148: FROM Fv_Ye_Groups

1144:
1145: -- Looking for group_id for just the timeframe parameter
1146: OPEN vc_groupid FOR
1147: 'SELECT group_id
1148: FROM Fv_Ye_Groups
1149: WHERE treasury_symbol_id IS NULL
1150: AND fund_group_code IS NULL
1151: AND fund_time_frame = :timeframe
1152: AND set_of_books_id = :sob_id'

Line 3983: Fv_Ye_Groups fyg ,

3979: END IF;
3980:
3981: L_select_stmt := ' SELECT ffp.fund_value
3982: FROM fv_fund_parameters ffp,
3983: Fv_Ye_Groups fyg ,
3984: fv_treasury_symbols fts
3985: WHERE fyg.fund_group_code = fts.fund_group_code
3986: AND fts.time_frame = fyg.fund_time_frame
3987: AND fts.treasury_symbol_id = fyg.treasury_symbol_id