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 323: per_all_assignments_f paaf,

319: paaf.employee_category,
320: payroll_id,
321: hsck.segment2 local_unit_id
322: FROM
323: per_all_assignments_f paaf,
324: per_jobs pj , --new
325: hr_soft_coding_keyflex hsck
326: WHERE assignment_id=csr_v_assignment_id --21197 --21257 --21233
327: AND csr_v_start_date <=paaf.EFFECTIVE_END_DATE AND

Line 360: FROM per_all_assignments_f

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

Line 370: per_all_assignments_f

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

Line 377: /*SELECT employee_category FROM per_all_assignments_f

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

Line 408: FROM per_all_assignments_f paaf,

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

Line 490: FROM per_all_assignments_f

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

Line 505: per_all_assignments_f paaf,

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

Line 515: per_all_assignments_f paaf,

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

Line 521: FROM per_all_assignments_f

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

Line 541: l_employee_category per_all_assignments_f.employee_category%type;

537: l_assignment_start_date DATE;
538: l_assignment_end_date DATE;
539: l_absence_count NUMBER;
540: l_insurance_number varchar2(10);
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: l_white_collar_from DATE;
545: l_terminated VARCHAR2(50);

Line 570: l_category per_all_assignments_f.employee_category%type;

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

Line 573: l_prev_category per_all_assignments_f.employee_category%type;

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

Line 2121: l_employee_category per_all_assignments_f.employee_category%type;

2117:
2118:
2119: /* Cursor to fetch Header Information */
2120:
2121: l_employee_category per_all_assignments_f.employee_category%type;
2122: l_lu_salary NUMBER;
2123: l_salary NUMBER:=0;
2124: l_grand_salary NUMBER:=0;
2125: