eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_EXTRA_PER_INFO_LEG_HOOK dependencies on PER_PEOPLE_EXTRA_INFO

Line 33: l_information_type per_people_extra_info.information_type%TYPE;

29: ,P_PEI_INFORMATION9 in VARCHAR2)
30:
31: is
32: l_filing_status_code varchar2(2);
33: l_information_type per_people_extra_info.information_type%TYPE;
34: l_pei_information_category per_people_extra_info.pei_information_category%TYPE;
35: l_pei_information5 per_people_extra_info.pei_information5%TYPE;
36: l_pei_information9 per_people_extra_info.pei_information9%TYPE;
37: l_person_id per_people_f.person_id%TYPE;

Line 34: l_pei_information_category per_people_extra_info.pei_information_category%TYPE;

30:
31: is
32: l_filing_status_code varchar2(2);
33: l_information_type per_people_extra_info.information_type%TYPE;
34: l_pei_information_category per_people_extra_info.pei_information_category%TYPE;
35: l_pei_information5 per_people_extra_info.pei_information5%TYPE;
36: l_pei_information9 per_people_extra_info.pei_information9%TYPE;
37: l_person_id per_people_f.person_id%TYPE;
38: l_withholding_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;

Line 35: l_pei_information5 per_people_extra_info.pei_information5%TYPE;

31: is
32: l_filing_status_code varchar2(2);
33: l_information_type per_people_extra_info.information_type%TYPE;
34: l_pei_information_category per_people_extra_info.pei_information_category%TYPE;
35: l_pei_information5 per_people_extra_info.pei_information5%TYPE;
36: l_pei_information9 per_people_extra_info.pei_information9%TYPE;
37: l_person_id per_people_f.person_id%TYPE;
38: l_withholding_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
39: l_fit_exempt pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;

Line 36: l_pei_information9 per_people_extra_info.pei_information9%TYPE;

32: l_filing_status_code varchar2(2);
33: l_information_type per_people_extra_info.information_type%TYPE;
34: l_pei_information_category per_people_extra_info.pei_information_category%TYPE;
35: l_pei_information5 per_people_extra_info.pei_information5%TYPE;
36: l_pei_information9 per_people_extra_info.pei_information9%TYPE;
37: l_person_id per_people_f.person_id%TYPE;
38: l_withholding_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
39: l_fit_exempt pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
40: l_wa_fed pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;

Line 43: l_student per_people_extra_info.pei_information1%TYPE;

39: l_fit_exempt pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
40: l_wa_fed pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
41: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
42: l_student_flag varchar2(3);
43: l_student per_people_extra_info.pei_information1%TYPE;
44: l_business_apprentice per_people_extra_info.pei_information2%TYPE;
45:
46:
47: cursor csr_chk_student_status is

Line 44: l_business_apprentice per_people_extra_info.pei_information2%TYPE;

40: l_wa_fed pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
41: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
42: l_student_flag varchar2(3);
43: l_student per_people_extra_info.pei_information1%TYPE;
44: l_business_apprentice per_people_extra_info.pei_information2%TYPE;
45:
46:
47: cursor csr_chk_student_status is
48: select pei_information1,pei_information2

Line 49: from per_people_extra_info

45:
46:
47: cursor csr_chk_student_status is
48: select pei_information1,pei_information2
49: from per_people_extra_info
50: where person_id=l_person_id
51: and information_type like 'PER_US_ADDITIONAL_DETAILS'
52: and pei_information_category like 'PER_US_ADDITIONAL_DETAILS'
53: and (pei_information1 = 'Y' or pei_information2 = 'Y');

Line 159: l_information_type per_people_extra_info.information_type%TYPE;/* stores per us additional details*/

155:
156: is
157: l_filing_status_code varchar2(2);
158: l_person_id per_all_people_f.person_id%TYPE;
159: l_information_type per_people_extra_info.information_type%TYPE;/* stores per us additional details*/
160: l_pei_information_category per_people_extra_info.pei_information_category%TYPE;/* stores per us additional details*/
161: l_information_type_1 per_people_extra_info.information_type%TYPE;/* stores per us student details*/
162: l_pei_information_category_1 per_people_extra_info.pei_information_category%TYPE;/* stores per us student details*/
163: l_pei_information1 per_people_extra_info.pei_information1%TYPE;

Line 160: l_pei_information_category per_people_extra_info.pei_information_category%TYPE;/* stores per us additional details*/

156: is
157: l_filing_status_code varchar2(2);
158: l_person_id per_all_people_f.person_id%TYPE;
159: l_information_type per_people_extra_info.information_type%TYPE;/* stores per us additional details*/
160: l_pei_information_category per_people_extra_info.pei_information_category%TYPE;/* stores per us additional details*/
161: l_information_type_1 per_people_extra_info.information_type%TYPE;/* stores per us student details*/
162: l_pei_information_category_1 per_people_extra_info.pei_information_category%TYPE;/* stores per us student details*/
163: l_pei_information1 per_people_extra_info.pei_information1%TYPE;
164: l_pei_information2 per_people_extra_info.pei_information2%TYPE;

Line 161: l_information_type_1 per_people_extra_info.information_type%TYPE;/* stores per us student details*/

157: l_filing_status_code varchar2(2);
158: l_person_id per_all_people_f.person_id%TYPE;
159: l_information_type per_people_extra_info.information_type%TYPE;/* stores per us additional details*/
160: l_pei_information_category per_people_extra_info.pei_information_category%TYPE;/* stores per us additional details*/
161: l_information_type_1 per_people_extra_info.information_type%TYPE;/* stores per us student details*/
162: l_pei_information_category_1 per_people_extra_info.pei_information_category%TYPE;/* stores per us student details*/
163: l_pei_information1 per_people_extra_info.pei_information1%TYPE;
164: l_pei_information2 per_people_extra_info.pei_information2%TYPE;
165: l_pei_information5 per_people_extra_info.pei_information5%TYPE;

Line 162: l_pei_information_category_1 per_people_extra_info.pei_information_category%TYPE;/* stores per us student details*/

158: l_person_id per_all_people_f.person_id%TYPE;
159: l_information_type per_people_extra_info.information_type%TYPE;/* stores per us additional details*/
160: l_pei_information_category per_people_extra_info.pei_information_category%TYPE;/* stores per us additional details*/
161: l_information_type_1 per_people_extra_info.information_type%TYPE;/* stores per us student details*/
162: l_pei_information_category_1 per_people_extra_info.pei_information_category%TYPE;/* stores per us student details*/
163: l_pei_information1 per_people_extra_info.pei_information1%TYPE;
164: l_pei_information2 per_people_extra_info.pei_information2%TYPE;
165: l_pei_information5 per_people_extra_info.pei_information5%TYPE;
166: l_pei_information9 per_people_extra_info.pei_information9%TYPE;

Line 163: l_pei_information1 per_people_extra_info.pei_information1%TYPE;

159: l_information_type per_people_extra_info.information_type%TYPE;/* stores per us additional details*/
160: l_pei_information_category per_people_extra_info.pei_information_category%TYPE;/* stores per us additional details*/
161: l_information_type_1 per_people_extra_info.information_type%TYPE;/* stores per us student details*/
162: l_pei_information_category_1 per_people_extra_info.pei_information_category%TYPE;/* stores per us student details*/
163: l_pei_information1 per_people_extra_info.pei_information1%TYPE;
164: l_pei_information2 per_people_extra_info.pei_information2%TYPE;
165: l_pei_information5 per_people_extra_info.pei_information5%TYPE;
166: l_pei_information9 per_people_extra_info.pei_information9%TYPE;
167: l_pei_information9_1 per_people_extra_info.pei_information9%TYPE;

Line 164: l_pei_information2 per_people_extra_info.pei_information2%TYPE;

160: l_pei_information_category per_people_extra_info.pei_information_category%TYPE;/* stores per us additional details*/
161: l_information_type_1 per_people_extra_info.information_type%TYPE;/* stores per us student details*/
162: l_pei_information_category_1 per_people_extra_info.pei_information_category%TYPE;/* stores per us student details*/
163: l_pei_information1 per_people_extra_info.pei_information1%TYPE;
164: l_pei_information2 per_people_extra_info.pei_information2%TYPE;
165: l_pei_information5 per_people_extra_info.pei_information5%TYPE;
166: l_pei_information9 per_people_extra_info.pei_information9%TYPE;
167: l_pei_information9_1 per_people_extra_info.pei_information9%TYPE;
168: l_person_extra_info_id per_people_extra_info.person_extra_info_id%TYPE;

Line 165: l_pei_information5 per_people_extra_info.pei_information5%TYPE;

161: l_information_type_1 per_people_extra_info.information_type%TYPE;/* stores per us student details*/
162: l_pei_information_category_1 per_people_extra_info.pei_information_category%TYPE;/* stores per us student details*/
163: l_pei_information1 per_people_extra_info.pei_information1%TYPE;
164: l_pei_information2 per_people_extra_info.pei_information2%TYPE;
165: l_pei_information5 per_people_extra_info.pei_information5%TYPE;
166: l_pei_information9 per_people_extra_info.pei_information9%TYPE;
167: l_pei_information9_1 per_people_extra_info.pei_information9%TYPE;
168: l_person_extra_info_id per_people_extra_info.person_extra_info_id%TYPE;
169: l_withholding_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;

Line 166: l_pei_information9 per_people_extra_info.pei_information9%TYPE;

162: l_pei_information_category_1 per_people_extra_info.pei_information_category%TYPE;/* stores per us student details*/
163: l_pei_information1 per_people_extra_info.pei_information1%TYPE;
164: l_pei_information2 per_people_extra_info.pei_information2%TYPE;
165: l_pei_information5 per_people_extra_info.pei_information5%TYPE;
166: l_pei_information9 per_people_extra_info.pei_information9%TYPE;
167: l_pei_information9_1 per_people_extra_info.pei_information9%TYPE;
168: l_person_extra_info_id per_people_extra_info.person_extra_info_id%TYPE;
169: l_withholding_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
170: l_wa_fed pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;

Line 167: l_pei_information9_1 per_people_extra_info.pei_information9%TYPE;

163: l_pei_information1 per_people_extra_info.pei_information1%TYPE;
164: l_pei_information2 per_people_extra_info.pei_information2%TYPE;
165: l_pei_information5 per_people_extra_info.pei_information5%TYPE;
166: l_pei_information9 per_people_extra_info.pei_information9%TYPE;
167: l_pei_information9_1 per_people_extra_info.pei_information9%TYPE;
168: l_person_extra_info_id per_people_extra_info.person_extra_info_id%TYPE;
169: l_withholding_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
170: l_wa_fed pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
171: l_fit_exempt pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;

Line 168: l_person_extra_info_id per_people_extra_info.person_extra_info_id%TYPE;

164: l_pei_information2 per_people_extra_info.pei_information2%TYPE;
165: l_pei_information5 per_people_extra_info.pei_information5%TYPE;
166: l_pei_information9 per_people_extra_info.pei_information9%TYPE;
167: l_pei_information9_1 per_people_extra_info.pei_information9%TYPE;
168: l_person_extra_info_id per_people_extra_info.person_extra_info_id%TYPE;
169: l_withholding_allowances pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
170: l_wa_fed pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
171: l_fit_exempt pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
172: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

Line 174: l_student per_people_extra_info.pei_information1%TYPE;

170: l_wa_fed pay_us_emp_fed_tax_rules_f.withholding_allowances%TYPE;
171: l_fit_exempt pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
172: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
173: l_student_flag varchar2(3);
174: l_student per_people_extra_info.pei_information1%TYPE;
175: l_business_apprentice per_people_extra_info.pei_information2%TYPE;
176:
177: /* This cursor checks whether any information exists for the employee that he is either a student or business apprentice*/
178: cursor csr_chk_student_status is

Line 175: l_business_apprentice per_people_extra_info.pei_information2%TYPE;

171: l_fit_exempt pay_us_emp_fed_tax_rules_f.fit_exempt%TYPE;
172: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
173: l_student_flag varchar2(3);
174: l_student per_people_extra_info.pei_information1%TYPE;
175: l_business_apprentice per_people_extra_info.pei_information2%TYPE;
176:
177: /* This cursor checks whether any information exists for the employee that he is either a student or business apprentice*/
178: cursor csr_chk_student_status is
179: select pei_information1,pei_information2

Line 180: from per_people_extra_info

176:
177: /* This cursor checks whether any information exists for the employee that he is either a student or business apprentice*/
178: cursor csr_chk_student_status is
179: select pei_information1,pei_information2
180: from per_people_extra_info
181: where person_id=l_person_id
182: and information_type like 'PER_US_ADDITIONAL_DETAILS'
183: and pei_information_category like 'PER_US_ADDITIONAL_DETAILS'
184: and (pei_information1 = 'Y' or pei_information2 = 'Y');

Line 198: FROM per_people_extra_info pei

194:
195: CURSOR get_person_id(p_person_extra_info_id NUMBER)
196: IS
197: SELECT person_id
198: FROM per_people_extra_info pei
199: WHERE pei.person_extra_info_id=p_person_extra_info_id;
200:
201:
202: CURSOR get_information_type(p_person_extra_info_id NUMBER)

Line 205: FROM per_people_extra_info pei

201:
202: CURSOR get_information_type(p_person_extra_info_id NUMBER)
203: IS
204: SELECT information_type
205: FROM per_people_extra_info pei
206: WHERE pei.person_extra_info_id=p_person_extra_info_id;
207:
208: CURSOR get_wa_fed(p_assignment_id NUMBER)
209: IS

Line 289: from per_people_extra_info where person_id=l_person_id

285: l_information_type_1 :='PER_US_ADDITIONAL_DETAILS';
286: l_pei_information_category_1 :='PER_US_ADDITIONAL_DETAILS';
287:
288: select pei_information9 into l_pei_information9_1 /* select find the country of the persosn */
289: from per_people_extra_info where person_id=l_person_id
290: and information_type like 'PER_US_ADDITIONAL_DETAILS'
291: and pei_information_category like 'PER_US_ADDITIONAL_DETAILS';
292: end if;
293: close csr_chk_student_status;