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.PQP_ALIEN_EXPAT_TAXATION_PKG dependencies on PER_PEOPLE_F

Line 5: person_id per_people_f.person_id%TYPE ,

1: PACKAGE pqp_alien_expat_taxation_pkg AUTHID DEFINER AS
2: /* $Header: pqalnexp.pkh 120.0.12010000.1 2008/07/28 11:07:48 appldev ship $ */
3: TYPE t_people_rec_type IS RECORD
4: (
5: person_id per_people_f.person_id%TYPE ,
6: last_name per_people_f.last_name%TYPE ,
7: first_name per_people_f.first_name%TYPE ,
8: middle_names per_people_f.middle_names%TYPE ,
9: national_identifier per_people_f.national_identifier%TYPE ,

Line 6: last_name per_people_f.last_name%TYPE ,

2: /* $Header: pqalnexp.pkh 120.0.12010000.1 2008/07/28 11:07:48 appldev ship $ */
3: TYPE t_people_rec_type IS RECORD
4: (
5: person_id per_people_f.person_id%TYPE ,
6: last_name per_people_f.last_name%TYPE ,
7: first_name per_people_f.first_name%TYPE ,
8: middle_names per_people_f.middle_names%TYPE ,
9: national_identifier per_people_f.national_identifier%TYPE ,
10: employee_number per_people_f.employee_number%TYPE ,

Line 7: first_name per_people_f.first_name%TYPE ,

3: TYPE t_people_rec_type IS RECORD
4: (
5: person_id per_people_f.person_id%TYPE ,
6: last_name per_people_f.last_name%TYPE ,
7: first_name per_people_f.first_name%TYPE ,
8: middle_names per_people_f.middle_names%TYPE ,
9: national_identifier per_people_f.national_identifier%TYPE ,
10: employee_number per_people_f.employee_number%TYPE ,
11: date_of_birth per_people_f.date_of_birth%TYPE ,

Line 8: middle_names per_people_f.middle_names%TYPE ,

4: (
5: person_id per_people_f.person_id%TYPE ,
6: last_name per_people_f.last_name%TYPE ,
7: first_name per_people_f.first_name%TYPE ,
8: middle_names per_people_f.middle_names%TYPE ,
9: national_identifier per_people_f.national_identifier%TYPE ,
10: employee_number per_people_f.employee_number%TYPE ,
11: date_of_birth per_people_f.date_of_birth%TYPE ,
12: title per_people_f.title%TYPE ,

Line 9: national_identifier per_people_f.national_identifier%TYPE ,

5: person_id per_people_f.person_id%TYPE ,
6: last_name per_people_f.last_name%TYPE ,
7: first_name per_people_f.first_name%TYPE ,
8: middle_names per_people_f.middle_names%TYPE ,
9: national_identifier per_people_f.national_identifier%TYPE ,
10: employee_number per_people_f.employee_number%TYPE ,
11: date_of_birth per_people_f.date_of_birth%TYPE ,
12: title per_people_f.title%TYPE ,
13: suffix per_people_f.suffix%TYPE ,

Line 10: employee_number per_people_f.employee_number%TYPE ,

6: last_name per_people_f.last_name%TYPE ,
7: first_name per_people_f.first_name%TYPE ,
8: middle_names per_people_f.middle_names%TYPE ,
9: national_identifier per_people_f.national_identifier%TYPE ,
10: employee_number per_people_f.employee_number%TYPE ,
11: date_of_birth per_people_f.date_of_birth%TYPE ,
12: title per_people_f.title%TYPE ,
13: suffix per_people_f.suffix%TYPE ,
14: marital_status per_people_f.marital_status%TYPE ,

Line 11: date_of_birth per_people_f.date_of_birth%TYPE ,

7: first_name per_people_f.first_name%TYPE ,
8: middle_names per_people_f.middle_names%TYPE ,
9: national_identifier per_people_f.national_identifier%TYPE ,
10: employee_number per_people_f.employee_number%TYPE ,
11: date_of_birth per_people_f.date_of_birth%TYPE ,
12: title per_people_f.title%TYPE ,
13: suffix per_people_f.suffix%TYPE ,
14: marital_status per_people_f.marital_status%TYPE ,
15: spouse_here VARCHAR2(30) ,

Line 12: title per_people_f.title%TYPE ,

8: middle_names per_people_f.middle_names%TYPE ,
9: national_identifier per_people_f.national_identifier%TYPE ,
10: employee_number per_people_f.employee_number%TYPE ,
11: date_of_birth per_people_f.date_of_birth%TYPE ,
12: title per_people_f.title%TYPE ,
13: suffix per_people_f.suffix%TYPE ,
14: marital_status per_people_f.marital_status%TYPE ,
15: spouse_here VARCHAR2(30) ,
16: dependents NUMBER ,

Line 13: suffix per_people_f.suffix%TYPE ,

9: national_identifier per_people_f.national_identifier%TYPE ,
10: employee_number per_people_f.employee_number%TYPE ,
11: date_of_birth per_people_f.date_of_birth%TYPE ,
12: title per_people_f.title%TYPE ,
13: suffix per_people_f.suffix%TYPE ,
14: marital_status per_people_f.marital_status%TYPE ,
15: spouse_here VARCHAR2(30) ,
16: dependents NUMBER ,
17: address_line1 hr_locations.address_line_1%TYPE ,

Line 14: marital_status per_people_f.marital_status%TYPE ,

10: employee_number per_people_f.employee_number%TYPE ,
11: date_of_birth per_people_f.date_of_birth%TYPE ,
12: title per_people_f.title%TYPE ,
13: suffix per_people_f.suffix%TYPE ,
14: marital_status per_people_f.marital_status%TYPE ,
15: spouse_here VARCHAR2(30) ,
16: dependents NUMBER ,
17: address_line1 hr_locations.address_line_1%TYPE ,
18: address_line2 hr_locations.address_line_2%TYPE ,

Line 50: person_id per_people_f.person_id%TYPE ,

46: *****/
47:
48: TYPE t_balance_rec_type IS RECORD
49: (
50: person_id per_people_f.person_id%TYPE ,
51: last_name per_people_f.last_name%TYPE ,
52: first_name per_people_f.first_name%TYPE ,
53: middle_names per_people_f.middle_names%TYPE ,
54: national_identifier per_people_f.national_identifier%TYPE ,

Line 51: last_name per_people_f.last_name%TYPE ,

47:
48: TYPE t_balance_rec_type IS RECORD
49: (
50: person_id per_people_f.person_id%TYPE ,
51: last_name per_people_f.last_name%TYPE ,
52: first_name per_people_f.first_name%TYPE ,
53: middle_names per_people_f.middle_names%TYPE ,
54: national_identifier per_people_f.national_identifier%TYPE ,
55: date_of_birth per_people_f.date_of_birth%TYPE ,

Line 52: first_name per_people_f.first_name%TYPE ,

48: TYPE t_balance_rec_type IS RECORD
49: (
50: person_id per_people_f.person_id%TYPE ,
51: last_name per_people_f.last_name%TYPE ,
52: first_name per_people_f.first_name%TYPE ,
53: middle_names per_people_f.middle_names%TYPE ,
54: national_identifier per_people_f.national_identifier%TYPE ,
55: date_of_birth per_people_f.date_of_birth%TYPE ,
56: income_code pqp_analyzed_alien_details.income_code%TYPE,

Line 53: middle_names per_people_f.middle_names%TYPE ,

49: (
50: person_id per_people_f.person_id%TYPE ,
51: last_name per_people_f.last_name%TYPE ,
52: first_name per_people_f.first_name%TYPE ,
53: middle_names per_people_f.middle_names%TYPE ,
54: national_identifier per_people_f.national_identifier%TYPE ,
55: date_of_birth per_people_f.date_of_birth%TYPE ,
56: income_code pqp_analyzed_alien_details.income_code%TYPE,
57: exemption_code pqp_analyzed_alien_details.exemption_code%TYPE,

Line 54: national_identifier per_people_f.national_identifier%TYPE ,

50: person_id per_people_f.person_id%TYPE ,
51: last_name per_people_f.last_name%TYPE ,
52: first_name per_people_f.first_name%TYPE ,
53: middle_names per_people_f.middle_names%TYPE ,
54: national_identifier per_people_f.national_identifier%TYPE ,
55: date_of_birth per_people_f.date_of_birth%TYPE ,
56: income_code pqp_analyzed_alien_details.income_code%TYPE,
57: exemption_code pqp_analyzed_alien_details.exemption_code%TYPE,
58: gross_amount NUMBER ,

Line 55: date_of_birth per_people_f.date_of_birth%TYPE ,

51: last_name per_people_f.last_name%TYPE ,
52: first_name per_people_f.first_name%TYPE ,
53: middle_names per_people_f.middle_names%TYPE ,
54: national_identifier per_people_f.national_identifier%TYPE ,
55: date_of_birth per_people_f.date_of_birth%TYPE ,
56: income_code pqp_analyzed_alien_details.income_code%TYPE,
57: exemption_code pqp_analyzed_alien_details.exemption_code%TYPE,
58: gross_amount NUMBER ,
59: withholding_allowance

Line 85: person_id per_people_f.person_id%TYPE ,

81: *****/
82:
83: TYPE t_visa_rec_type IS RECORD
84: (
85: person_id per_people_f.person_id%TYPE ,
86: last_name per_people_f.last_name%TYPE ,
87: first_name per_people_f.first_name%TYPE ,
88: middle_names per_people_f.middle_names%TYPE ,
89: national_identifier per_people_f.national_identifier%TYPE ,

Line 86: last_name per_people_f.last_name%TYPE ,

82:
83: TYPE t_visa_rec_type IS RECORD
84: (
85: person_id per_people_f.person_id%TYPE ,
86: last_name per_people_f.last_name%TYPE ,
87: first_name per_people_f.first_name%TYPE ,
88: middle_names per_people_f.middle_names%TYPE ,
89: national_identifier per_people_f.national_identifier%TYPE ,
90: date_of_birth per_people_f.date_of_birth%TYPE ,

Line 87: first_name per_people_f.first_name%TYPE ,

83: TYPE t_visa_rec_type IS RECORD
84: (
85: person_id per_people_f.person_id%TYPE ,
86: last_name per_people_f.last_name%TYPE ,
87: first_name per_people_f.first_name%TYPE ,
88: middle_names per_people_f.middle_names%TYPE ,
89: national_identifier per_people_f.national_identifier%TYPE ,
90: date_of_birth per_people_f.date_of_birth%TYPE ,
91: visa_type VARCHAR2(100) ,

Line 88: middle_names per_people_f.middle_names%TYPE ,

84: (
85: person_id per_people_f.person_id%TYPE ,
86: last_name per_people_f.last_name%TYPE ,
87: first_name per_people_f.first_name%TYPE ,
88: middle_names per_people_f.middle_names%TYPE ,
89: national_identifier per_people_f.national_identifier%TYPE ,
90: date_of_birth per_people_f.date_of_birth%TYPE ,
91: visa_type VARCHAR2(100) ,
92: j_category_code VARCHAR2(100) ,

Line 89: national_identifier per_people_f.national_identifier%TYPE ,

85: person_id per_people_f.person_id%TYPE ,
86: last_name per_people_f.last_name%TYPE ,
87: first_name per_people_f.first_name%TYPE ,
88: middle_names per_people_f.middle_names%TYPE ,
89: national_identifier per_people_f.national_identifier%TYPE ,
90: date_of_birth per_people_f.date_of_birth%TYPE ,
91: visa_type VARCHAR2(100) ,
92: j_category_code VARCHAR2(100) ,
93: primary_activity_code VARCHAR2(100) ,

Line 90: date_of_birth per_people_f.date_of_birth%TYPE ,

86: last_name per_people_f.last_name%TYPE ,
87: first_name per_people_f.first_name%TYPE ,
88: middle_names per_people_f.middle_names%TYPE ,
89: national_identifier per_people_f.national_identifier%TYPE ,
90: date_of_birth per_people_f.date_of_birth%TYPE ,
91: visa_type VARCHAR2(100) ,
92: j_category_code VARCHAR2(100) ,
93: primary_activity_code VARCHAR2(100) ,
94: visa_start_date DATE ,

Line 104: ( id per_people_f.person_id%TYPE ,

100: /*****
101: The above Record Type stores the data selected of the visa information
102: *****/
103: TYPE t_payment_export_type IS RECORD
104: ( id per_people_f.person_id%TYPE ,
105: last_name per_people_f.last_name%TYPE ,
106: first_name per_people_f.first_name%TYPE ,
107: middle_names per_people_f.middle_names%TYPE ,
108: system_id_number NUMBER ,

Line 105: last_name per_people_f.last_name%TYPE ,

101: The above Record Type stores the data selected of the visa information
102: *****/
103: TYPE t_payment_export_type IS RECORD
104: ( id per_people_f.person_id%TYPE ,
105: last_name per_people_f.last_name%TYPE ,
106: first_name per_people_f.first_name%TYPE ,
107: middle_names per_people_f.middle_names%TYPE ,
108: system_id_number NUMBER ,
109: social_security_number VARCHAR2(11) ,

Line 106: first_name per_people_f.first_name%TYPE ,

102: *****/
103: TYPE t_payment_export_type IS RECORD
104: ( id per_people_f.person_id%TYPE ,
105: last_name per_people_f.last_name%TYPE ,
106: first_name per_people_f.first_name%TYPE ,
107: middle_names per_people_f.middle_names%TYPE ,
108: system_id_number NUMBER ,
109: social_security_number VARCHAR2(11) ,
110: institution_indiv_id VARCHAR2(15) ,

Line 107: middle_names per_people_f.middle_names%TYPE ,

103: TYPE t_payment_export_type IS RECORD
104: ( id per_people_f.person_id%TYPE ,
105: last_name per_people_f.last_name%TYPE ,
106: first_name per_people_f.first_name%TYPE ,
107: middle_names per_people_f.middle_names%TYPE ,
108: system_id_number NUMBER ,
109: social_security_number VARCHAR2(11) ,
110: institution_indiv_id VARCHAR2(15) ,
111: date_of_birth DATE ,

Line 167: person_id per_people_f.person_id%TYPE ,

163: The above Record Type stores the message for error processing
164: *****/
165: TYPE t_error_rec_type IS RECORD
166: (
167: person_id per_people_f.person_id%TYPE ,
168: process_event_id pay_process_events.process_event_id%TYPE
169: );
170:
171: TYPE t_error_tab_type IS TABLE OF t_error_rec_type INDEX BY BINARY_INTEGER;