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

Line 255: per_all_people_f WHERE

251: CURSOR csr_employee_details(csr_v_person_id number, csr_v_end_date date)
252: IS
253: SELECT national_identifier, last_name || ' ' || first_name name ,DATE_OF_BIRTH
254: FROM
255: per_all_people_f WHERE
256: BUSINESS_GROUP_ID=g_business_group_id
257: AND person_id=csr_v_person_id
258: AND csr_v_end_date
259: BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

Line 276: SELECT MAX(effective_start_date) FROM per_all_people_f papf WHERE

272: AND employee_category='WC' ;
273:
274: CURSOR csr_termination(csr_v_person_id number, csr_v_start_date date, csr_v_end_date date)
275: IS
276: SELECT MAX(effective_start_date) FROM per_all_people_f papf WHERE
277: CURRENT_EMPLOYEE_FLAG IS NULL
278: AND person_id=csr_v_person_id--21257
279: AND EFFECTIVE_END_DATE --'31-dec-2000'
280: BETWEEN csr_v_start_date AND csr_v_end_date /*'01-jan-2000' AND csr_v_end_date '31-dec-2000'*/

Line 282: (SELECT 1 FROM per_all_people_f WHERE

278: AND person_id=csr_v_person_id--21257
279: AND EFFECTIVE_END_DATE --'31-dec-2000'
280: BETWEEN csr_v_start_date AND csr_v_end_date /*'01-jan-2000' AND csr_v_end_date '31-dec-2000'*/
281: AND NOT EXISTS
282: (SELECT 1 FROM per_all_people_f WHERE
283: CURRENT_EMPLOYEE_FLAG='Y'
284: AND person_id=papf.person_id --21257
285: AND effective_start_date >papf.effective_start_date
286: );

Line 291: per_all_people_f papf,

287: CURSOR csr_assignment_details(csr_v_person_id NUMBER,csr_v_start_date date, csr_v_end_date date)
288: IS
289: /*SELECT effective_start_date,effective_end_date,pj.JOB_INFORMATION1,employee_category
290: FROM
291: per_all_people_f papf,
292: per_jobs pj
293: WHERE person_id=csr_v_person_id --21257 --21233
294: AND csr_v_start_date<=EFFECTIVE_END_DATE AND
295: csr_v_end_date>=EFFECTIVE_START_DATE

Line 386: per_all_people_f papf,

382: CURSOR csr_person_local_unit(csr_v_business_group_id number, csr_v_local_unit_id number, csr_v_effective_date date)
383: IS
384: SELECT papf.person_id --,paaf.assignment_id
385: FROM per_all_assignments_f paaf,
386: per_all_people_f papf,
387: hr_soft_coding_keyflex hsck
388: WHERE papf.business_group_id=csr_v_business_group_id -- 3133 --paaf.assignment_id = p_assignment_id
389: AND paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
390: AND papf.person_id=paaf.person_id

Line 428: ,per_all_people_f per

424: SELECT greatest(fnd_Date.canonical_to_date(eev1.screen_entry_value),csr_v_start_date) start_date,
425: least(fnd_Date.canonical_to_date(eev2.screen_entry_value),csr_v_end_date) end_date
426: FROM per_all_assignments_f asg1
427: ,per_all_assignments_f asg2
428: ,per_all_people_f per
429: ,pay_element_links_f el
430: ,pay_element_types_f et
431: ,pay_input_values_f iv1
432: ,pay_input_values_f iv2

Line 542: l_person_number per_all_people_f.national_identifier%TYPE;

538: l_assignment_start_date DATE;
539: l_assignment_end_date DATE;
540: l_absence_count NUMBER;
541: l_employee_category per_all_assignments_f.employee_category%type;
542: l_person_number per_all_people_f.national_identifier%TYPE;
543: l_person_name VARCHAR2(350);
544:
545: l_terminated VARCHAR2(50);
546:

Line 558: l_date_birth per_all_people_f.DATE_OF_BIRTH%TYPE;

554: l_assignment_action_id pay_Assignment_actions.assignment_action_id%type;
555: L_CFAR_NUMBER NUMBER;
556: l_legal_employer_id NUMBER;
557: l_virtual_date DATE;
558: l_date_birth per_all_people_f.DATE_OF_BIRTH%TYPE;
559: l_counter NUMBER :=0;
560: l_total_salary NUMBER;
561: l_asg_start_date DATE;
562: l_asg_end_date date;

Line 761: per_all_people_f WHERE

757: CURSOR csr_employee_details(csr_v_person_id number, csr_v_end_date date)
758: IS
759: SELECT national_identifier, last_name || ' ' || first_name name ,DATE_OF_BIRTH
760: FROM
761: per_all_people_f WHERE
762: BUSINESS_GROUP_ID=g_business_group_id
763: AND person_id=csr_v_person_id
764: AND csr_v_end_date
765: BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

Line 782: SELECT MAX(effective_start_date) FROM per_all_people_f papf WHERE

778: AND employee_category='WC' ;
779:
780: CURSOR csr_termination(csr_v_person_id number, csr_v_start_date date, csr_v_end_date date)
781: IS
782: SELECT MAX(effective_start_date) FROM per_all_people_f papf WHERE
783: CURRENT_EMPLOYEE_FLAG IS NULL
784: AND person_id=csr_v_person_id--21257
785: AND EFFECTIVE_END_DATE --'31-dec-2000'
786: BETWEEN csr_v_start_date AND csr_v_end_date /*'01-jan-2000' AND csr_v_end_date '31-dec-2000'*/

Line 788: (SELECT 1 FROM per_all_people_f WHERE

784: AND person_id=csr_v_person_id--21257
785: AND EFFECTIVE_END_DATE --'31-dec-2000'
786: BETWEEN csr_v_start_date AND csr_v_end_date /*'01-jan-2000' AND csr_v_end_date '31-dec-2000'*/
787: AND NOT EXISTS
788: (SELECT 1 FROM per_all_people_f WHERE
789: CURRENT_EMPLOYEE_FLAG='Y'
790: AND person_id=papf.person_id --21257
791: AND effective_start_date >papf.effective_start_date
792: );

Line 797: per_all_people_f papf,

793: CURSOR csr_assignment_details(csr_v_person_id NUMBER,csr_v_start_date date, csr_v_end_date date)
794: IS
795: /*SELECT effective_start_date,effective_end_date,pj.JOB_INFORMATION1,employee_category
796: FROM
797: per_all_people_f papf,
798: per_jobs pj
799: WHERE person_id=csr_v_person_id --21257 --21233
800: AND csr_v_start_date<=EFFECTIVE_END_DATE AND
801: csr_v_end_date>=EFFECTIVE_START_DATE

Line 892: per_all_people_f papf,

888: CURSOR csr_person_local_unit(csr_v_business_group_id number, csr_v_local_unit_id number, csr_v_effective_date date)
889: IS
890: SELECT distinct papf.person_id --,paaf.assignment_id
891: FROM per_all_assignments_f paaf,
892: per_all_people_f papf,
893: hr_soft_coding_keyflex hsck
894: WHERE papf.business_group_id=csr_v_business_group_id -- 3133 --paaf.assignment_id = p_assignment_id
895: AND paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
896: AND papf.person_id=paaf.person_id

Line 940: -- per_all_people_f papf

936: paaf.normal_hours,
937: paaf.payroll_id
938: FROM per_all_assignments_f paaf,
939: hr_soft_coding_keyflex hsck --,
940: -- per_all_people_f papf
941: WHERE paaf.business_group_id=csr_v_business_group_id
942: -- papf.person_id=paaf.person_id
943: and paaf.person_id between p_start_person and p_end_person
944: --AND paaf.primary_flag='Y'

Line 966: ,per_all_people_f per

962: SELECT greatest(fnd_Date.canonical_to_date(eev1.screen_entry_value),csr_v_start_date) start_date,
963: least(fnd_Date.canonical_to_date(eev2.screen_entry_value),csr_v_end_date) end_date
964: FROM per_all_assignments_f asg1
965: ,per_all_assignments_f asg2
966: ,per_all_people_f per
967: ,pay_element_links_f el
968: ,pay_element_types_f et
969: ,pay_input_values_f iv1
970: ,pay_input_values_f iv2

Line 1107: per_all_people_f papf,

1103:
1104: cursor csr_person_assignment(csr_v_assignment_id number, csr_v_start_date date,csr_v_end_date date)
1105: is
1106: select 1 from
1107: per_all_people_f papf,
1108: per_all_assignments_f paaf
1109: where papf.person_id=paaf.person_id
1110: and paaf.assignment_id=csr_v_assignment_id
1111: and csr_v_end_date /*'01-jan-2006'*/ BETWEEN papf.effective_start_date

Line 1167: l_person_number per_all_people_f.national_identifier%TYPE;

1163: l_assignment_start_date DATE;
1164: l_assignment_end_date DATE;
1165: l_absence_count NUMBER;
1166: l_employee_category per_all_assignments_f.employee_category%type;
1167: l_person_number per_all_people_f.national_identifier%TYPE;
1168: l_person_name VARCHAR2(350);
1169:
1170: l_terminated VARCHAR2(50);
1171:

Line 1183: l_date_birth per_all_people_f.DATE_OF_BIRTH%TYPE;

1179: l_assignment_action_id pay_Assignment_actions.assignment_action_id%type;
1180: L_CFAR_NUMBER NUMBER;
1181: l_legal_employer_id NUMBER;
1182: l_virtual_date DATE;
1183: l_date_birth per_all_people_f.DATE_OF_BIRTH%TYPE;
1184: l_counter NUMBER :=0;
1185: l_total_salary NUMBER;
1186: l_asg_start_date DATE;
1187: l_asg_end_date date;