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_ASSIGNMENTS_F

Line 267: SELECT effective_start_date FROM per_all_assignments_f

263:
264:
265: CURSOR csr_white_collar(csr_v_person_id number, csr_v_end_date date)
266: IS
267: SELECT effective_start_date FROM per_all_assignments_f
268: WHERE person_id=csr_v_person_id --21233
269: AND csr_v_end_date
270: BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
271: AND primary_flag='Y'

Line 305: per_all_assignments_f paaf,

301: SELECT paaf.effective_start_date,paaf.effective_end_date,
302: decode(pj.JOB_INFORMATION1,'Y','M',null) job,paaf.employee_category,
303: payroll_id
304: FROM
305: per_all_assignments_f paaf,
306: per_jobs pj
307: WHERE person_id=csr_v_person_id --21197 --21257 --21233
308: AND csr_v_start_date <=paaf.EFFECTIVE_END_DATE AND
309: csr_v_end_date >=paaf.EFFECTIVE_START_DATE

Line 338: FROM per_all_assignments_f

334:
335: CURSOR csr_employee_category(csr_v_person_id number, csr_v_start_date DATE, csr_v_end_date date)
336: IS
337: SELECT DISTINCT employee_category ,EFFECTIVE_START_DATE
338: FROM per_all_assignments_f
339: WHERE person_id=csr_v_person_id --21257 --21233
340: AND csr_v_start_date<=EFFECTIVE_END_DATE AND
341: csr_v_end_date>=EFFECTIVE_START_DATE
342: AND primary_flag='Y'

Line 348: per_all_assignments_f

344:
345: CURSOR csr_employee_blue_max_date(csr_v_person_id number, csr_v_start_date DATE, csr_v_end_date date)
346: IS
347: SELECT MAX(EFFECTIVE_end_DATE) FROM
348: per_all_assignments_f
349: WHERE person_id=csr_v_person_id --21257 --21233
350: AND csr_v_start_date<=EFFECTIVE_END_DATE AND
351: csr_v_end_date>=EFFECTIVE_START_DATE
352: AND employee_category='BC'

Line 355: /*SELECT employee_category FROM per_all_assignments_f

351: csr_v_end_date>=EFFECTIVE_START_DATE
352: AND employee_category='BC'
353: AND primary_flag='Y';
354:
355: /*SELECT employee_category FROM per_all_assignments_f
356: WHERE person_id=csr_v_person_id --21233
357: AND csr_v_end_date
358: BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
359: AND primary_flag='Y';*/

Line 385: FROM per_all_assignments_f paaf,

381:
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

Line 412: FROM per_all_assignments_f paaf,

408: paaf.hourly_salaried_code,
409: hsck.SEGMENT9 working_percentage,
410: paaf.frequency,
411: paaf.normal_hours
412: FROM per_all_assignments_f paaf,
413: hr_soft_coding_keyflex hsck
414: WHERE paaf.person_id=csr_v_person_id
415: AND paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
416: AND csr_v_effective_date /*'01-jan-2006'*/ BETWEEN paaf.effective_start_date

Line 426: FROM per_all_assignments_f asg1

422: CURSOR csr_assignment_absence (csr_v_assignment_id number, csr_v_start_date date, csr_v_end_date date)
423: is
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

Line 427: ,per_all_assignments_f asg2

423: is
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

Line 541: l_employee_category per_all_assignments_f.employee_category%type;

537: l_assignment_category VARCHAR2(5);
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);

Line 563: l_category per_all_assignments_f.employee_category%type;

559: l_counter NUMBER :=0;
560: l_total_salary NUMBER;
561: l_asg_start_date DATE;
562: l_asg_end_date date;
563: l_category per_all_assignments_f.employee_category%type;
564: l_prev_category per_all_assignments_f.employee_category%type;
565: l_working_percentage NUMBER;
566: l_asg_hour_sal per_all_assignments_f.hourly_salaried_code%type;
567: l_frequency per_all_assignments_f.frequency%type;

Line 564: l_prev_category per_all_assignments_f.employee_category%type;

560: l_total_salary NUMBER;
561: l_asg_start_date DATE;
562: l_asg_end_date date;
563: l_category per_all_assignments_f.employee_category%type;
564: l_prev_category per_all_assignments_f.employee_category%type;
565: l_working_percentage NUMBER;
566: l_asg_hour_sal per_all_assignments_f.hourly_salaried_code%type;
567: l_frequency per_all_assignments_f.frequency%type;
568: l_normal_hours per_all_assignments_f.normal_hours%type;

Line 566: l_asg_hour_sal per_all_assignments_f.hourly_salaried_code%type;

562: l_asg_end_date date;
563: l_category per_all_assignments_f.employee_category%type;
564: l_prev_category per_all_assignments_f.employee_category%type;
565: l_working_percentage NUMBER;
566: l_asg_hour_sal per_all_assignments_f.hourly_salaried_code%type;
567: l_frequency per_all_assignments_f.frequency%type;
568: l_normal_hours per_all_assignments_f.normal_hours%type;
569: l_include_event char(1);
570: l_wrk_schd_return NUMBER;

Line 567: l_frequency per_all_assignments_f.frequency%type;

563: l_category per_all_assignments_f.employee_category%type;
564: l_prev_category per_all_assignments_f.employee_category%type;
565: l_working_percentage NUMBER;
566: l_asg_hour_sal per_all_assignments_f.hourly_salaried_code%type;
567: l_frequency per_all_assignments_f.frequency%type;
568: l_normal_hours per_all_assignments_f.normal_hours%type;
569: l_include_event char(1);
570: l_wrk_schd_return NUMBER;
571: l_wrk_duration NUMBER;

Line 568: l_normal_hours per_all_assignments_f.normal_hours%type;

564: l_prev_category per_all_assignments_f.employee_category%type;
565: l_working_percentage NUMBER;
566: l_asg_hour_sal per_all_assignments_f.hourly_salaried_code%type;
567: l_frequency per_all_assignments_f.frequency%type;
568: l_normal_hours per_all_assignments_f.normal_hours%type;
569: l_include_event char(1);
570: l_wrk_schd_return NUMBER;
571: l_wrk_duration NUMBER;
572: l_absence_start_date DATE;

Line 773: SELECT effective_start_date FROM per_all_assignments_f

769:
770:
771: CURSOR csr_white_collar(csr_v_person_id number, csr_v_end_date date)
772: IS
773: SELECT effective_start_date FROM per_all_assignments_f
774: WHERE person_id=csr_v_person_id --21233
775: AND csr_v_end_date
776: BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
777: AND primary_flag='Y'

Line 811: per_all_assignments_f paaf,

807: SELECT paaf.effective_start_date,paaf.effective_end_date,
808: decode(pj.JOB_INFORMATION1,'Y','M',null) job,paaf.employee_category,
809: payroll_id
810: FROM
811: per_all_assignments_f paaf,
812: per_jobs pj
813: WHERE person_id=csr_v_person_id --21197 --21257 --21233
814: AND csr_v_start_date <=paaf.EFFECTIVE_END_DATE AND
815: csr_v_end_date >=paaf.EFFECTIVE_START_DATE

Line 844: FROM per_all_assignments_f

840:
841: CURSOR csr_employee_category(csr_v_person_id number, csr_v_start_date DATE, csr_v_end_date date)
842: IS
843: SELECT DISTINCT employee_category ,EFFECTIVE_START_DATE
844: FROM per_all_assignments_f
845: WHERE person_id=csr_v_person_id --21257 --21233
846: AND csr_v_start_date<=EFFECTIVE_END_DATE AND
847: csr_v_end_date>=EFFECTIVE_START_DATE
848: AND primary_flag='Y'

Line 854: per_all_assignments_f

850:
851: CURSOR csr_employee_blue_max_date(csr_v_person_id number, csr_v_start_date DATE, csr_v_end_date date)
852: IS
853: SELECT MAX(EFFECTIVE_end_DATE) FROM
854: per_all_assignments_f
855: WHERE person_id=csr_v_person_id --21257 --21233
856: AND csr_v_start_date<=EFFECTIVE_END_DATE AND
857: csr_v_end_date>=EFFECTIVE_START_DATE
858: AND employee_category='BC'

Line 861: /*SELECT employee_category FROM per_all_assignments_f

857: csr_v_end_date>=EFFECTIVE_START_DATE
858: AND employee_category='BC'
859: AND primary_flag='Y';
860:
861: /*SELECT employee_category FROM per_all_assignments_f
862: WHERE person_id=csr_v_person_id --21233
863: AND csr_v_end_date
864: BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
865: AND primary_flag='Y';*/

Line 891: FROM per_all_assignments_f paaf,

887:
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

Line 919: FROM per_all_assignments_f paaf,

915: paaf.hourly_salaried_code,
916: fnd_number.canonical_to_number(hsck.SEGMENT9) working_percentage,
917: paaf.frequency,
918: paaf.normal_hours
919: FROM per_all_assignments_f paaf,
920: hr_soft_coding_keyflex hsck
921: WHERE paaf.person_id=csr_v_person_id
922: AND paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id
923: AND csr_v_effective_date /*'01-jan-2006'*/ BETWEEN paaf.effective_start_date

Line 938: FROM per_all_assignments_f paaf,

934: fnd_number.canonical_to_number(hsck.SEGMENT9) working_percentage,
935: paaf.frequency,
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

Line 964: FROM per_all_assignments_f asg1

960: CURSOR csr_assignment_absence (csr_v_assignment_id number, csr_v_start_date date, csr_v_end_date date)
961: is
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

Line 965: ,per_all_assignments_f asg2

961: is
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

Line 1108: per_all_assignments_f paaf

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
1112: AND papf.effective_end_date

Line 1149: FROM per_all_assignments_f

1145:
1146: /*CURSOR csr_payroll(csr_v_assignment_id NUMBER, csr_v_start_date DATE, csr_v_end_date DATE)
1147: IS
1148: SELECT payroll_id
1149: FROM per_all_assignments_f
1150: WHERE assignment_id=csr_v_assignment_id
1151: AND csr_v_end_date BETWEEN effective_start_date AND
1152: effective_end_date*/
1153:

Line 1166: l_employee_category per_all_assignments_f.employee_category%type;

1162: l_assignment_category VARCHAR2(5);
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);

Line 1188: l_category per_all_assignments_f.employee_category%type;

1184: l_counter NUMBER :=0;
1185: l_total_salary NUMBER;
1186: l_asg_start_date DATE;
1187: l_asg_end_date date;
1188: l_category per_all_assignments_f.employee_category%type;
1189: l_prev_category per_all_assignments_f.employee_category%type;
1190: l_working_percentage NUMBER;
1191: l_asg_hour_sal per_all_assignments_f.hourly_salaried_code%type;
1192: l_frequency per_all_assignments_f.frequency%type;

Line 1189: l_prev_category per_all_assignments_f.employee_category%type;

1185: l_total_salary NUMBER;
1186: l_asg_start_date DATE;
1187: l_asg_end_date date;
1188: l_category per_all_assignments_f.employee_category%type;
1189: l_prev_category per_all_assignments_f.employee_category%type;
1190: l_working_percentage NUMBER;
1191: l_asg_hour_sal per_all_assignments_f.hourly_salaried_code%type;
1192: l_frequency per_all_assignments_f.frequency%type;
1193: l_normal_hours per_all_assignments_f.normal_hours%type;

Line 1191: l_asg_hour_sal per_all_assignments_f.hourly_salaried_code%type;

1187: l_asg_end_date date;
1188: l_category per_all_assignments_f.employee_category%type;
1189: l_prev_category per_all_assignments_f.employee_category%type;
1190: l_working_percentage NUMBER;
1191: l_asg_hour_sal per_all_assignments_f.hourly_salaried_code%type;
1192: l_frequency per_all_assignments_f.frequency%type;
1193: l_normal_hours per_all_assignments_f.normal_hours%type;
1194: l_include_event char(1);
1195: l_wrk_schd_return NUMBER;

Line 1192: l_frequency per_all_assignments_f.frequency%type;

1188: l_category per_all_assignments_f.employee_category%type;
1189: l_prev_category per_all_assignments_f.employee_category%type;
1190: l_working_percentage NUMBER;
1191: l_asg_hour_sal per_all_assignments_f.hourly_salaried_code%type;
1192: l_frequency per_all_assignments_f.frequency%type;
1193: l_normal_hours per_all_assignments_f.normal_hours%type;
1194: l_include_event char(1);
1195: l_wrk_schd_return NUMBER;
1196: l_wrk_duration NUMBER;

Line 1193: l_normal_hours per_all_assignments_f.normal_hours%type;

1189: l_prev_category per_all_assignments_f.employee_category%type;
1190: l_working_percentage NUMBER;
1191: l_asg_hour_sal per_all_assignments_f.hourly_salaried_code%type;
1192: l_frequency per_all_assignments_f.frequency%type;
1193: l_normal_hours per_all_assignments_f.normal_hours%type;
1194: l_include_event char(1);
1195: l_wrk_schd_return NUMBER;
1196: l_wrk_duration NUMBER;
1197: l_absence_start_date DATE;

Line 1259: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

1255: l_period_start per_time_periods.start_date%TYPE;
1256: l_period_end per_time_periods.end_date%TYPE;
1257: l_bh_worked_period NUMBER:=0;
1258: l_work_hours_days char(1):='D';
1259: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
1260:
1261: TYPE emp_cat_type
1262: IS TABLE OF VARCHAR2(10)
1263: INDEX BY BINARY_INTEGER;

Line 3594: l_employee_category per_all_assignments_f.employee_category%type;

3590:
3591:
3592: /* Cursor to fetch Header Information */
3593:
3594: l_employee_category per_all_assignments_f.employee_category%type;
3595: l_lu_salary NUMBER;
3596: l_salary NUMBER:=0;
3597: l_grand_salary NUMBER:=0;
3598: l_legal_employer hr_organization_units.name%type;