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_GET_ITEM_DATA_PKG dependencies on PER_ALL_PEOPLE_F

Line 156: CURSOR get_person_infm(c_person_id per_all_people_f.person_id%TYPE,

152: ) RETURN VARCHAR2 IS
153:
154: -- Cursor to fetch Contact person Name and Email Address
155: --
156: CURSOR get_person_infm(c_person_id per_all_people_f.person_id%TYPE,
157: c_date_earned date)
158: IS
159: SELECT ppf.first_name ||' '||ppf.middle_names||' '||ppf.last_name,
160: ppf.email_address,

Line 165: FROM per_all_people_f ppf

161: ppf.first_name,
162: ppf.middle_names,
163: ppf.last_name,
164: ppf.title
165: FROM per_all_people_f ppf
166: WHERE ppf.person_id = c_person_id
167: AND c_date_earned BETWEEN ppf.effective_start_date
168: AND ppf.effective_end_date;
169:

Line 172: CURSOR get_phone_fax(c_person_id per_all_people_f.person_id%TYPE,

168: AND ppf.effective_end_date;
169:
170: -- Cursor to fetch Contact person Phone and Fax #
171: --
172: CURSOR get_phone_fax(c_person_id per_all_people_f.person_id%TYPE,
173: c_date date)
174: IS
175: SELECT phone_number,
176: phone_type

Line 181: AND parent_table = 'PER_ALL_PEOPLE_F';

177: FROM per_phones
178: WHERE parent_id = c_person_id
179: AND c_date BETWEEN date_from
180: AND nvl(date_to,end_Date)
181: AND parent_table = 'PER_ALL_PEOPLE_F';
182:
183: -- Another Cursor to fetch the Position Title for MD (Bug 9571133)
184:
185:

Line 210: l_full_name per_all_people_f.full_name%TYPE := '';

206:
207: c_item_name varchar2(100);
208: l_valid_address boolean;
209: l_person_id varchar2(50);
210: l_full_name per_all_people_f.full_name%TYPE := '';
211: l_first_name per_all_people_f.first_name%TYPE := '';
212: l_middle_name per_all_people_f.middle_names%TYPE := '';
213: l_last_name per_all_people_f.last_name%TYPE := '';
214: l_phone per_phones.phone_number%TYPE := '';

Line 211: l_first_name per_all_people_f.first_name%TYPE := '';

207: c_item_name varchar2(100);
208: l_valid_address boolean;
209: l_person_id varchar2(50);
210: l_full_name per_all_people_f.full_name%TYPE := '';
211: l_first_name per_all_people_f.first_name%TYPE := '';
212: l_middle_name per_all_people_f.middle_names%TYPE := '';
213: l_last_name per_all_people_f.last_name%TYPE := '';
214: l_phone per_phones.phone_number%TYPE := '';
215: l_extension varchar2(5) := '';

Line 212: l_middle_name per_all_people_f.middle_names%TYPE := '';

208: l_valid_address boolean;
209: l_person_id varchar2(50);
210: l_full_name per_all_people_f.full_name%TYPE := '';
211: l_first_name per_all_people_f.first_name%TYPE := '';
212: l_middle_name per_all_people_f.middle_names%TYPE := '';
213: l_last_name per_all_people_f.last_name%TYPE := '';
214: l_phone per_phones.phone_number%TYPE := '';
215: l_extension varchar2(5) := '';
216: l_phone_type per_phones.phone_type%TYPE := '';

Line 213: l_last_name per_all_people_f.last_name%TYPE := '';

209: l_person_id varchar2(50);
210: l_full_name per_all_people_f.full_name%TYPE := '';
211: l_first_name per_all_people_f.first_name%TYPE := '';
212: l_middle_name per_all_people_f.middle_names%TYPE := '';
213: l_last_name per_all_people_f.last_name%TYPE := '';
214: l_phone per_phones.phone_number%TYPE := '';
215: l_extension varchar2(5) := '';
216: l_phone_type per_phones.phone_type%TYPE := '';
217: l_fax per_phones.phone_number%TYPE := '';

Line 218: l_email per_all_people_f.email_address%TYPE := '';

214: l_phone per_phones.phone_number%TYPE := '';
215: l_extension varchar2(5) := '';
216: l_phone_type per_phones.phone_type%TYPE := '';
217: l_fax per_phones.phone_number%TYPE := '';
218: l_email per_all_people_f.email_address%TYPE := '';
219: l_title per_all_people_f.title%TYPE := '';
220: l_position hr_all_positions_f.name%TYPE := '';
221:
222: BEGIN

Line 219: l_title per_all_people_f.title%TYPE := '';

215: l_extension varchar2(5) := '';
216: l_phone_type per_phones.phone_type%TYPE := '';
217: l_fax per_phones.phone_number%TYPE := '';
218: l_email per_all_people_f.email_address%TYPE := '';
219: l_title per_all_people_f.title%TYPE := '';
220: l_position hr_all_positions_f.name%TYPE := '';
221:
222: BEGIN
223:

Line 766: , per_all_people_f ppf

762: IS
763: SELECT ppf.full_name ,
764: ppf.employee_number
765: from per_all_assignments_f assign
766: , per_all_people_f ppf
767: where ASSIGN.assignment_id = c_assignment_id
768: and c_effective_date BETWEEN ASSIGN.effective_start_date
769: AND ASSIGN.effective_end_date
770: and assign.person_id = ppf.person_id

Line 799: , per_all_people_f ppf

795: addr.region_2 ,
796: 'Y' valid_address
797: from per_all_assignments_f assign
798: , per_addresses addr
799: , per_all_people_f ppf
800: , fnd_territories_tl fttl
801: , fnd_territories ftt
802: , hr_lookups hrt
803: where ASSIGN.assignment_id = c_assignment_id

Line 844: , per_all_people_f PPF

840: addr.region_2 ,
841: 'Y' valid_address
842: FROM per_all_assignments_f ASSIGN
843: , per_addresses ADDR
844: , per_all_people_f PPF
845: , fnd_territories_tl fttl
846: , fnd_territories ftt
847: , hr_lookups hrt
848: where ASSIGN.assignment_id = c_assignment_id

Line 866: (c_person_id per_all_people_f.person_id%type,

862: -- For any report that needs to fetch person name and address inputing
863: -- person_id and effective date.
864: --
865: CURSOR get_report_name_address
866: (c_person_id per_all_people_f.person_id%type,
867: c_effective_date date)
868: IS
869: SELECT ppf.full_name ,
870: ppf.employee_number ,

Line 885: , per_all_people_f PPF

881: addr.region_1 ,
882: addr.region_2 ,
883: 'Y' valid_address
884: FROM per_addresses ADDR
885: , per_all_people_f PPF
886: , fnd_territories_tl fttl
887: , fnd_territories ftt
888: , hr_lookups hrt
889: where ppf.person_id = c_person_id

Line 908: (c_person_id per_all_people_f.person_id%type)

904: -- address when effective date is greater then period_end_date
905: -- for instance for W2, if effective_date is greater then year end date
906: -- this will b
907: CURSOR get_report_name_address_eod
908: (c_person_id per_all_people_f.person_id%type)
909: IS
910: SELECT ppf.full_name ,
911: ppf.employee_number ,
912: addr.address_line1 ,

Line 926: , per_all_people_f ppf

922: addr.region_1 ,
923: addr.region_2 ,
924: 'Y' valid_address
925: FROM per_addresses addr
926: , per_all_people_f ppf
927: , fnd_territories_tl fttl
928: , fnd_territories ftt
929: , hr_lookups hrt
930: where ppf.person_id = c_person_id

Line 945: (c_person_id per_all_people_f.person_id%type,

941: --
942: -- This cursor would be used for W2, 1099R report to fetch Person Name
943: -- and Employee Number
944: CURSOR get_report_person_name
945: (c_person_id per_all_people_f.person_id%type,
946: c_effective_date date)
947: IS
948: SELECT ppf.full_name ,
949: ppf.employee_number

Line 950: from per_all_people_f ppf

946: c_effective_date date)
947: IS
948: SELECT ppf.full_name ,
949: ppf.employee_number
950: from per_all_people_f ppf
951: where ppf.person_id = c_person_id
952: and c_effective_date BETWEEN ppf.effective_start_date
953: AND ppf.effective_end_date;
954:

Line 957: l_emp_number per_all_people_f.employee_number%type;

953: AND ppf.effective_end_date;
954:
955: l_addr_count number(10) := 0;
956: l_valid_address varchar2(3) := 'N';
957: l_emp_number per_all_people_f.employee_number%type;
958: l_full_name per_all_people_f.full_name%TYPE;
959: /*
960: l_address_line_1 per_addresses.address_line1%type;
961: l_address_line_2 per_addresses.address_line2%type;

Line 958: l_full_name per_all_people_f.full_name%TYPE;

954:
955: l_addr_count number(10) := 0;
956: l_valid_address varchar2(3) := 'N';
957: l_emp_number per_all_people_f.employee_number%type;
958: l_full_name per_all_people_f.full_name%TYPE;
959: /*
960: l_address_line_1 per_addresses.address_line1%type;
961: l_address_line_2 per_addresses.address_line2%type;
962: l_address_line_3 per_addresses.address_line3%type;