APPS.IGS_AD_WF_001 dependencies on IGS_PE_PERSON_BASE_V

Line 36: FROM igs_pe_person_base_v

32:
33: -- Get Person number and full name.
34: CURSOR get_person_attr IS
35: SELECT person_number, full_name
36: FROM igs_pe_person_base_v
37: WHERE person_id = p_person_id;
38:
39: CURSOR get_application_id IS
40: SELECT application_id

Line 54: l_person_number igs_pe_person_base_v.person_number%TYPE;

50:
51: l_cur_prof_value cur_prof_value%ROWTYPE;
52: lv_raise_event VARCHAR2(100);
53: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
54: l_person_number igs_pe_person_base_v.person_number%TYPE;
55: l_person_name igs_pe_person_base_v.full_name%TYPE;
56: l_application_id igs_ad_appl_all.application_id%TYPE;
57: l_wf_role fnd_user.user_name%TYPE;
58:

Line 55: l_person_name igs_pe_person_base_v.full_name%TYPE;

51: l_cur_prof_value cur_prof_value%ROWTYPE;
52: lv_raise_event VARCHAR2(100);
53: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
54: l_person_number igs_pe_person_base_v.person_number%TYPE;
55: l_person_name igs_pe_person_base_v.full_name%TYPE;
56: l_application_id igs_ad_appl_all.application_id%TYPE;
57: l_wf_role fnd_user.user_name%TYPE;
58:
59:

Line 136: l_person_number igs_pe_person_base_v.person_number%TYPE;

132: ln_seq_val NUMBER;
133: lv_raise_event VARCHAR2(30);
134: lv_item_type VARCHAR2(100) ;
135: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
136: l_person_number igs_pe_person_base_v.person_number%TYPE;
137: l_person_name igs_pe_person_base_v.full_name%TYPE;
138: l_application_id igs_ad_appl_all.application_id%TYPE;
139: l_wf_role fnd_user.user_name%TYPE;
140:

Line 137: l_person_name igs_pe_person_base_v.full_name%TYPE;

133: lv_raise_event VARCHAR2(30);
134: lv_item_type VARCHAR2(100) ;
135: l_parameter_list wf_parameter_list_t := wf_parameter_list_t();
136: l_person_number igs_pe_person_base_v.person_number%TYPE;
137: l_person_name igs_pe_person_base_v.full_name%TYPE;
138: l_application_id igs_ad_appl_all.application_id%TYPE;
139: l_wf_role fnd_user.user_name%TYPE;
140:
141:

Line 150: FROM igs_pe_person_base_v

146:
147: -- Get Person number and full name.
148: CURSOR get_person_attr IS
149: SELECT person_number, full_name
150: FROM igs_pe_person_base_v
151: WHERE person_id = p_person_id;
152:
153: CURSOR get_application_id IS
154: SELECT application_id