DBA Data[Home] [Help]

APPS.IGF_AW_COA_GEN dependencies on IGS_PE_STD_TODO

Line 1841: -- Inserts records into IGS_PE_STD_TODO and IGS_PE_STD_TODO_REF for the given person_id,

1837: --Created by : veramach, Oracle India
1838: --Date created: 07-OCT-2004
1839: --
1840: --Purpose:
1841: -- Inserts records into IGS_PE_STD_TODO and IGS_PE_STD_TODO_REF for the given person_id,
1842: -- thereby scheduling a COA Recomputation via concurrent process for the given person, in all open award years
1843: --
1844: -- Parameters:
1845: -- IN Parameters:

Line 1877: l_seqnum igs_pe_std_todo.sequence_number%TYPE;

1873: AND fa.person_id = cp_person_id
1874: GROUP BY batch.ci_cal_type,
1875: batch.ci_sequence_number;
1876:
1877: l_seqnum igs_pe_std_todo.sequence_number%TYPE;
1878:
1879: -- Get persons with specified key program
1880: CURSOR c_persons(
1881: cp_program_code igs_ps_ver.course_cd%TYPE,