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 145: CURSOR get_person_infm(c_person_id per_all_people_f.person_id%TYPE,

141: ) RETURN VARCHAR2 IS
142:
143: -- Cursor to fetch Contact person Name and Email Address
144: --
145: CURSOR get_person_infm(c_person_id per_all_people_f.person_id%TYPE,
146: c_date_earned date)
147: IS
148: SELECT ppf.first_name ||' '||ppf.middle_names||' '||ppf.last_name,
149: ppf.email_address,

Line 154: FROM per_all_people_f ppf

150: ppf.first_name,
151: ppf.middle_names,
152: ppf.last_name,
153: ppf.title
154: FROM per_all_people_f ppf
155: WHERE ppf.person_id = c_person_id
156: AND c_date_earned BETWEEN ppf.effective_start_date
157: AND ppf.effective_end_date;
158:

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

157: AND ppf.effective_end_date;
158:
159: -- Cursor to fetch Contact person Phone and Fax #
160: --
161: CURSOR get_phone_fax(c_person_id per_all_people_f.person_id%TYPE,
162: c_date date)
163: IS
164: SELECT phone_number,
165: phone_type

Line 170: AND parent_table = 'PER_ALL_PEOPLE_F';

166: FROM per_phones
167: WHERE parent_id = c_person_id
168: AND c_date BETWEEN date_from
169: AND nvl(date_to,end_Date)
170: AND parent_table = 'PER_ALL_PEOPLE_F';
171:
172: c_item_name varchar2(100);
173: l_valid_address boolean;
174: l_person_id varchar2(50);

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

171:
172: c_item_name varchar2(100);
173: l_valid_address boolean;
174: l_person_id varchar2(50);
175: l_full_name per_all_people_f.full_name%TYPE := '';
176: l_first_name per_all_people_f.first_name%TYPE := '';
177: l_middle_name per_all_people_f.middle_names%TYPE := '';
178: l_last_name per_all_people_f.last_name%TYPE := '';
179: l_phone per_phones.phone_number%TYPE := '';

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

172: c_item_name varchar2(100);
173: l_valid_address boolean;
174: l_person_id varchar2(50);
175: l_full_name per_all_people_f.full_name%TYPE := '';
176: l_first_name per_all_people_f.first_name%TYPE := '';
177: l_middle_name per_all_people_f.middle_names%TYPE := '';
178: l_last_name per_all_people_f.last_name%TYPE := '';
179: l_phone per_phones.phone_number%TYPE := '';
180: l_extension varchar2(5) := '';

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

173: l_valid_address boolean;
174: l_person_id varchar2(50);
175: l_full_name per_all_people_f.full_name%TYPE := '';
176: l_first_name per_all_people_f.first_name%TYPE := '';
177: l_middle_name per_all_people_f.middle_names%TYPE := '';
178: l_last_name per_all_people_f.last_name%TYPE := '';
179: l_phone per_phones.phone_number%TYPE := '';
180: l_extension varchar2(5) := '';
181: l_phone_type per_phones.phone_type%TYPE := '';

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

174: l_person_id varchar2(50);
175: l_full_name per_all_people_f.full_name%TYPE := '';
176: l_first_name per_all_people_f.first_name%TYPE := '';
177: l_middle_name per_all_people_f.middle_names%TYPE := '';
178: l_last_name per_all_people_f.last_name%TYPE := '';
179: l_phone per_phones.phone_number%TYPE := '';
180: l_extension varchar2(5) := '';
181: l_phone_type per_phones.phone_type%TYPE := '';
182: l_fax per_phones.phone_number%TYPE := '';

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

179: l_phone per_phones.phone_number%TYPE := '';
180: l_extension varchar2(5) := '';
181: l_phone_type per_phones.phone_type%TYPE := '';
182: l_fax per_phones.phone_number%TYPE := '';
183: l_email per_all_people_f.email_address%TYPE := '';
184: l_title per_all_people_f.title%TYPE := '';
185:
186: BEGIN
187: c_item_name:='CR_PERSON';

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

180: l_extension varchar2(5) := '';
181: l_phone_type per_phones.phone_type%TYPE := '';
182: l_fax per_phones.phone_number%TYPE := '';
183: l_email per_all_people_f.email_address%TYPE := '';
184: l_title per_all_people_f.title%TYPE := '';
185:
186: BEGIN
187: c_item_name:='CR_PERSON';
188: l_valid_address:=FALSE;

Line 649: , per_all_people_f ppf

645: IS
646: SELECT ppf.full_name ,
647: ppf.employee_number
648: from per_all_assignments_f assign
649: , per_all_people_f ppf
650: where ASSIGN.assignment_id = c_assignment_id
651: and c_effective_date BETWEEN ASSIGN.effective_start_date
652: AND ASSIGN.effective_end_date
653: and assign.person_id = ppf.person_id

Line 682: , per_all_people_f ppf

678: addr.region_2 ,
679: 'Y' valid_address
680: from per_all_assignments_f assign
681: , per_addresses addr
682: , per_all_people_f ppf
683: , fnd_territories_tl fttl
684: , fnd_territories ftt
685: , hr_lookups hrt
686: where ASSIGN.assignment_id = c_assignment_id

Line 727: , per_all_people_f PPF

723: addr.region_2 ,
724: 'Y' valid_address
725: FROM per_all_assignments_f ASSIGN
726: , per_addresses ADDR
727: , per_all_people_f PPF
728: , fnd_territories_tl fttl
729: , fnd_territories ftt
730: , hr_lookups hrt
731: where ASSIGN.assignment_id = c_assignment_id

Line 749: (c_person_id per_all_people_f.person_id%type,

745: -- For any report that needs to fetch person name and address inputing
746: -- person_id and effective date.
747: --
748: CURSOR get_report_name_address
749: (c_person_id per_all_people_f.person_id%type,
750: c_effective_date date)
751: IS
752: SELECT ppf.full_name ,
753: ppf.employee_number ,

Line 768: , per_all_people_f PPF

764: addr.region_1 ,
765: addr.region_2 ,
766: 'Y' valid_address
767: FROM per_addresses ADDR
768: , per_all_people_f PPF
769: , fnd_territories_tl fttl
770: , fnd_territories ftt
771: , hr_lookups hrt
772: where ppf.person_id = c_person_id

Line 791: (c_person_id per_all_people_f.person_id%type)

787: -- address when effective date is greater then period_end_date
788: -- for instance for W2, if effective_date is greater then year end date
789: -- this will b
790: CURSOR get_report_name_address_eod
791: (c_person_id per_all_people_f.person_id%type)
792: IS
793: SELECT ppf.full_name ,
794: ppf.employee_number ,
795: addr.address_line1 ,

Line 809: , per_all_people_f ppf

805: addr.region_1 ,
806: addr.region_2 ,
807: 'Y' valid_address
808: FROM per_addresses addr
809: , per_all_people_f ppf
810: , fnd_territories_tl fttl
811: , fnd_territories ftt
812: , hr_lookups hrt
813: where ppf.person_id = c_person_id

Line 828: (c_person_id per_all_people_f.person_id%type,

824: --
825: -- This cursor would be used for W2, 1099R report to fetch Person Name
826: -- and Employee Number
827: CURSOR get_report_person_name
828: (c_person_id per_all_people_f.person_id%type,
829: c_effective_date date)
830: IS
831: SELECT ppf.full_name ,
832: ppf.employee_number

Line 833: from per_all_people_f ppf

829: c_effective_date date)
830: IS
831: SELECT ppf.full_name ,
832: ppf.employee_number
833: from per_all_people_f ppf
834: where ppf.person_id = c_person_id
835: and c_effective_date BETWEEN ppf.effective_start_date
836: AND ppf.effective_end_date;
837:

Line 840: l_emp_number per_all_people_f.employee_number%type;

836: AND ppf.effective_end_date;
837:
838: l_addr_count number(10) := 0;
839: l_valid_address varchar2(3) := 'N';
840: l_emp_number per_all_people_f.employee_number%type;
841: l_full_name per_all_people_f.full_name%TYPE;
842: /*
843: l_address_line_1 per_addresses.address_line1%type;
844: l_address_line_2 per_addresses.address_line2%type;

Line 841: l_full_name per_all_people_f.full_name%TYPE;

837:
838: l_addr_count number(10) := 0;
839: l_valid_address varchar2(3) := 'N';
840: l_emp_number per_all_people_f.employee_number%type;
841: l_full_name per_all_people_f.full_name%TYPE;
842: /*
843: l_address_line_1 per_addresses.address_line1%type;
844: l_address_line_2 per_addresses.address_line2%type;
845: l_address_line_3 per_addresses.address_line3%type;