APPS.FV_COPY_YE_RECORDS_PKG dependencies on FV_YE_GROUP_SEQUENCES

Line 15: FROM fv_ye_group_sequences

11:
12: CURSOR c_sequences
13: IS
14: SELECT *
15: FROM fv_ye_group_sequences
16: WHERE group_id = v_old_group_id
17: ORDER BY SEQUENCE;
18:
19: CURSOR c_accounts(cv_sequence_id NUMBER)

Line 30: v_sequence_id fv_ye_group_sequences.sequence_id%TYPE;

26: l_errbuff VARCHAR2(300);
27: v_login NUMBER;
28: v_set_of_books_id NUMBER;
29: v_new_group_id fv_ye_groups.group_id%TYPE;
30: v_sequence_id fv_ye_group_sequences.sequence_id%TYPE;
31: --pkpatel:Declared a new variable to fix Bug. 1575992
32: v_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
33:
34: BEGIN

Line 88: SELECT fv_ye_group_sequences_s.NEXTVAL

84: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
85: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,
86: 'SEQUENCE = '||C_SEQUENCES_REC.SEQUENCE);
87: END IF;
88: SELECT fv_ye_group_sequences_s.NEXTVAL
89: INTO v_sequence_id
90: FROM dual;
91:
92: INSERT INTO fv_ye_group_sequences

Line 92: INSERT INTO fv_ye_group_sequences

88: SELECT fv_ye_group_sequences_s.NEXTVAL
89: INTO v_sequence_id
90: FROM dual;
91:
92: INSERT INTO fv_ye_group_sequences
93: (sequence_id,
94: group_id,
95: SEQUENCE,
96: set_of_books_id,