DBA Data[Home] [Help]

APPS.PAY_IN_24QC_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 96: (person_id per_all_people_f.person_id%TYPE

92: TYPE t_screen_entry_table_data IS TABLE OF t_screen_entry_value_rec
93: INDEX BY binary_integer;
94:
95: TYPE t_person_data_rec IS RECORD
96: (person_id per_all_people_f.person_id%TYPE
97: ,pan_number per_all_people_f.per_information14%TYPE
98: ,pan_ref_number per_all_people_f.per_information14%TYPE
99: ,full_name per_all_people_f.full_name%TYPE
100: ,tax_rate per_assignment_extra_info.aei_information2 %TYPE

Line 97: ,pan_number per_all_people_f.per_information14%TYPE

93: INDEX BY binary_integer;
94:
95: TYPE t_person_data_rec IS RECORD
96: (person_id per_all_people_f.person_id%TYPE
97: ,pan_number per_all_people_f.per_information14%TYPE
98: ,pan_ref_number per_all_people_f.per_information14%TYPE
99: ,full_name per_all_people_f.full_name%TYPE
100: ,tax_rate per_assignment_extra_info.aei_information2 %TYPE
101: );

Line 98: ,pan_ref_number per_all_people_f.per_information14%TYPE

94:
95: TYPE t_person_data_rec IS RECORD
96: (person_id per_all_people_f.person_id%TYPE
97: ,pan_number per_all_people_f.per_information14%TYPE
98: ,pan_ref_number per_all_people_f.per_information14%TYPE
99: ,full_name per_all_people_f.full_name%TYPE
100: ,tax_rate per_assignment_extra_info.aei_information2 %TYPE
101: );
102:

Line 99: ,full_name per_all_people_f.full_name%TYPE

95: TYPE t_person_data_rec IS RECORD
96: (person_id per_all_people_f.person_id%TYPE
97: ,pan_number per_all_people_f.per_information14%TYPE
98: ,pan_ref_number per_all_people_f.per_information14%TYPE
99: ,full_name per_all_people_f.full_name%TYPE
100: ,tax_rate per_assignment_extra_info.aei_information2 %TYPE
101: );
102:
103: TYPE t_person_record IS TABLE OF t_person_data_rec

Line 107: (person_id per_all_people_f.person_id%TYPE

103: TYPE t_person_record IS TABLE OF t_person_data_rec
104: INDEX BY binary_integer;
105:
106: TYPE t_person_data_sal_rec IS RECORD
107: (person_id per_all_people_f.person_id%TYPE
108: ,pan_number per_all_people_f.per_information14%TYPE
109: ,pan_ref_number per_all_people_f.per_information14%TYPE
110: ,full_name per_all_people_f.full_name%TYPE
111: ,start_date DATE

Line 108: ,pan_number per_all_people_f.per_information14%TYPE

104: INDEX BY binary_integer;
105:
106: TYPE t_person_data_sal_rec IS RECORD
107: (person_id per_all_people_f.person_id%TYPE
108: ,pan_number per_all_people_f.per_information14%TYPE
109: ,pan_ref_number per_all_people_f.per_information14%TYPE
110: ,full_name per_all_people_f.full_name%TYPE
111: ,start_date DATE
112: ,end_date DATE

Line 109: ,pan_ref_number per_all_people_f.per_information14%TYPE

105:
106: TYPE t_person_data_sal_rec IS RECORD
107: (person_id per_all_people_f.person_id%TYPE
108: ,pan_number per_all_people_f.per_information14%TYPE
109: ,pan_ref_number per_all_people_f.per_information14%TYPE
110: ,full_name per_all_people_f.full_name%TYPE
111: ,start_date DATE
112: ,end_date DATE
113: );

Line 110: ,full_name per_all_people_f.full_name%TYPE

106: TYPE t_person_data_sal_rec IS RECORD
107: (person_id per_all_people_f.person_id%TYPE
108: ,pan_number per_all_people_f.per_information14%TYPE
109: ,pan_ref_number per_all_people_f.per_information14%TYPE
110: ,full_name per_all_people_f.full_name%TYPE
111: ,start_date DATE
112: ,end_date DATE
113: );
114: