APPS.IGS_CO_SUBMIT dependencies on IGS_PE_PERSON_BASE_V

Line 212: FROM igs_pe_person_base_v

208: -- Added cursor to print the person number in case of no email for bug 2742586
209: CURSOR c_person_number (pa_person_id NUMBER)
210: IS
211: SELECT person_number, full_name
212: FROM igs_pe_person_base_v
213: WHERE person_id = pa_person_id;
214:
215: l_person_number igs_pe_person_base_v.person_number%TYPE;
216: l_full_name igs_pe_person_base_v.full_name%TYPE;

Line 215: l_person_number igs_pe_person_base_v.person_number%TYPE;

211: SELECT person_number, full_name
212: FROM igs_pe_person_base_v
213: WHERE person_id = pa_person_id;
214:
215: l_person_number igs_pe_person_base_v.person_number%TYPE;
216: l_full_name igs_pe_person_base_v.full_name%TYPE;
217: l_cursor_id NUMBER (15);
218: l_num_of_rows NUMBER (15);
219: l_dsql_debug VARCHAR2 (32767);

Line 216: l_full_name igs_pe_person_base_v.full_name%TYPE;

212: FROM igs_pe_person_base_v
213: WHERE person_id = pa_person_id;
214:
215: l_person_number igs_pe_person_base_v.person_number%TYPE;
216: l_full_name igs_pe_person_base_v.full_name%TYPE;
217: l_cursor_id NUMBER (15);
218: l_num_of_rows NUMBER (15);
219: l_dsql_debug VARCHAR2 (32767);
220: l_person_processed NUMBER (10) := 0;

Line 1857: FROM igs_pe_person_base_v

1853: -- Cursor to log the person's processed
1854: CURSOR c_per_processed (cp_person_id NUMBER)
1855: IS
1856: SELECT person_number, full_name
1857: FROM igs_pe_person_base_v
1858: WHERE person_id = cp_person_id;
1859:
1860: -- Get version id of content for interaction history
1861: CURSOR c_content_version (

Line 1903: l_full_name igs_pe_person_base_v.full_name%TYPE;

1899: l_extended_header igs_co_prev_reqs.extended_header%TYPE;
1900: l_distribution_id igs_co_prev_reqs.distribution_id%TYPE;
1901: l_award_prd_cd igs_co_prev_reqs.award_prd_cd%TYPE;
1902: -- Person details...
1903: l_full_name igs_pe_person_base_v.full_name%TYPE;
1904: l_person_number igs_pe_person_base_v.person_number%TYPE;
1905: -- Version
1906: l_version ibc_citems_v.version%TYPE;
1907: -- Return status

Line 1904: l_person_number igs_pe_person_base_v.person_number%TYPE;

1900: l_distribution_id igs_co_prev_reqs.distribution_id%TYPE;
1901: l_award_prd_cd igs_co_prev_reqs.award_prd_cd%TYPE;
1902: -- Person details...
1903: l_full_name igs_pe_person_base_v.full_name%TYPE;
1904: l_person_number igs_pe_person_base_v.person_number%TYPE;
1905: -- Version
1906: l_version ibc_citems_v.version%TYPE;
1907: -- Return status
1908: l_return_status VARCHAR2 (30);