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_FORA dependencies on PER_ALL_ASSIGNMENTS_F

Line 283: SELECT effective_start_date FROM per_all_assignments_f

279:
280:
281: CURSOR csr_white_collar(csr_v_person_id number, csr_v_end_date date)
282: IS
283: SELECT effective_start_date FROM per_all_assignments_f
284: WHERE person_id=csr_v_person_id --21233
285: AND csr_v_end_date
286: BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
287: AND primary_flag='Y'

Line 322: per_all_assignments_f paaf,

318: decode(pj.JOB_INFORMATION1,'Y','M',null) job,paaf.employee_category,
319: payroll_id,
320: hsck.segment2 local_unit_id
321: FROM
322: per_all_assignments_f paaf,
323: per_jobs pj , --new
324: hr_soft_coding_keyflex hsck
325: WHERE assignment_id=csr_v_assignment_id --21197 --21257 --21233
326: AND csr_v_start_date <=paaf.EFFECTIVE_END_DATE AND

Line 359: FROM per_all_assignments_f

355:
356: CURSOR csr_employee_category(csr_v_person_id number, csr_v_start_date DATE, csr_v_end_date date)
357: IS
358: SELECT DISTINCT employee_category ,EFFECTIVE_START_DATE
359: FROM per_all_assignments_f
360: WHERE person_id=csr_v_person_id --21257 --21233
361: AND csr_v_start_date<=EFFECTIVE_END_DATE AND
362: csr_v_end_date>=EFFECTIVE_START_DATE
363: AND primary_flag='Y'

Line 369: per_all_assignments_f

365:
366: CURSOR csr_employee_blue_max_date(csr_v_person_id number, csr_v_start_date DATE, csr_v_end_date date)
367: IS
368: SELECT MAX(EFFECTIVE_end_DATE) FROM
369: per_all_assignments_f
370: WHERE person_id=csr_v_person_id --21257 --21233
371: AND csr_v_start_date<=EFFECTIVE_END_DATE AND
372: csr_v_end_date>=EFFECTIVE_START_DATE
373: AND employee_category='BC'

Line 376: /*SELECT employee_category FROM per_all_assignments_f

372: csr_v_end_date>=EFFECTIVE_START_DATE
373: AND employee_category='BC'
374: AND primary_flag='Y';
375:
376: /*SELECT employee_category FROM per_all_assignments_f
377: WHERE person_id=csr_v_person_id --21233
378: AND csr_v_end_date
379: BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
380: AND primary_flag='Y';*/

Line 407: FROM per_all_assignments_f paaf,

403: CURSOR csr_person_local_unit(csr_v_business_group_id number, csr_v_local_unit_id number, csr_v_effective_date date,
404: csr_v_end_date date)
405: IS
406: SELECT DISTINCT papf.person_id ,paaf.assignment_id
407: FROM per_all_assignments_f paaf,
408: per_all_people_f papf,
409: hr_soft_coding_keyflex hsck
410: WHERE papf.business_group_id=csr_v_business_group_id -- 3133 --paaf.assignment_id = p_assignment_id
411: AND paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id

Line 489: FROM per_all_assignments_f

485:
486: CURSOR csr_white_collar_from (csr_v_assignment_start_date DATE,csr_v_assignment_id NUMBER )
487: IS
488: SELECT min(effective_start_date)
489: FROM per_all_assignments_f
490: WHERE effective_start_date > csr_v_assignment_start_date --previous assignment start date
491: AND employee_category='WC'
492: AND assignment_id=csr_v_assignment_id;
493:

Line 504: per_all_assignments_f paaf,

500:
501: CURSOR csr_check_local_unit(csr_v_assignment_id NUMBER, csr_v_start_date DATE)
502: IS
503: SELECT hsck.segment2 FROM
504: per_all_assignments_f paaf,
505: hr_soft_coding_keyflex hsck
506: WHERE
507: paaf.assignment_id=csr_v_assignment_id
508: AND paaf.effective_start_date=csr_v_start_date

Line 514: per_all_assignments_f paaf,

510:
511: CURSOR csr_next_local_unit(csr_v_assignment_id NUMBER, csr_v_start_date DATE)
512: IS
513: SELECT hsck.segment2 FROM
514: per_all_assignments_f paaf,
515: hr_soft_coding_keyflex hsck
516: WHERE
517: paaf.assignment_id=csr_v_assignment_id
518: AND paaf.effective_start_date=

Line 520: FROM per_all_assignments_f

516: WHERE
517: paaf.assignment_id=csr_v_assignment_id
518: AND paaf.effective_start_date=
519: (SELECT min(effective_start_date)
520: FROM per_all_assignments_f
521: WHERE effective_start_date>csr_v_start_date
522: and assignment_id=paaf.assignment_id)
523: AND paaf.soft_coding_keyflex_id=hsck.soft_coding_keyflex_id;
524:

Line 540: l_employee_category per_all_assignments_f.employee_category%type;

536: l_assignment_start_date DATE;
537: l_assignment_end_date DATE;
538: l_absence_count NUMBER;
539: l_insurance_number varchar2(10);
540: l_employee_category per_all_assignments_f.employee_category%type;
541: l_person_number per_all_people_f.national_identifier%TYPE;
542: l_person_name VARCHAR2(350);
543: l_white_collar_from DATE;
544: l_terminated VARCHAR2(50);

Line 569: l_category per_all_assignments_f.employee_category%type;

565: l_total_salary NUMBER;
566: l_twenty_salary NUMBER;
567: l_asg_start_date DATE;
568: l_asg_end_date date;
569: l_category per_all_assignments_f.employee_category%type;
570: l_job varchar2(5);
571: l_prev_job varchar2(5);
572: l_prev_category per_all_assignments_f.employee_category%type;
573: l_period_start_date date;

Line 572: l_prev_category per_all_assignments_f.employee_category%type;

568: l_asg_end_date date;
569: l_category per_all_assignments_f.employee_category%type;
570: l_job varchar2(5);
571: l_prev_job varchar2(5);
572: l_prev_category per_all_assignments_f.employee_category%type;
573: l_period_start_date date;
574: l_period_end_date date;
575: l_start_gross_salary number(17,2);
576: l_end_gross_salary number(17,2);

Line 2095: l_employee_category per_all_assignments_f.employee_category%type;

2091:
2092:
2093: /* Cursor to fetch Header Information */
2094:
2095: l_employee_category per_all_assignments_f.employee_category%type;
2096: l_lu_salary NUMBER;
2097: l_salary NUMBER:=0;
2098: l_grand_salary NUMBER:=0;
2099: