APPS.FV_COPY_YE_RECORDS_PKG dependencies on FV_YE_GROUP_SEQUENCES

Line 17: FROM fv_ye_group_sequences

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

Line 32: v_sequence_id fv_ye_group_sequences.sequence_id%TYPE;

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

Line 92: SELECT fv_ye_group_sequences_s.NEXTVAL

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

Line 96: INSERT INTO fv_ye_group_sequences

92: SELECT fv_ye_group_sequences_s.NEXTVAL
93: INTO v_sequence_id
94: FROM dual;
95:
96: INSERT INTO fv_ye_group_sequences
97: (sequence_id,
98: group_id,
99: SEQUENCE,
100: set_of_books_id,