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

Line 451: csr_v_person_id per_all_assignments_f.person_id%TYPE

447: lr_contact_details csr_contact_details%ROWTYPE;
448:
449: -- To CHECK ACTIVE ASSIGNMENT OR TERMINATE
450: CURSOR csr_assign_status (
451: csr_v_person_id per_all_assignments_f.person_id%TYPE
452: ,csr_v_assignment_id per_all_assignments_f.assignment_id%TYPE
453: )
454: IS
455: SELECT past.per_system_status

Line 452: ,csr_v_assignment_id per_all_assignments_f.assignment_id%TYPE

448:
449: -- To CHECK ACTIVE ASSIGNMENT OR TERMINATE
450: CURSOR csr_assign_status (
451: csr_v_person_id per_all_assignments_f.person_id%TYPE
452: ,csr_v_assignment_id per_all_assignments_f.assignment_id%TYPE
453: )
454: IS
455: SELECT past.per_system_status
456: ,p.effective_start_date

Line 458: FROM per_all_assignments_f p

454: IS
455: SELECT past.per_system_status
456: ,p.effective_start_date
457: ,p.effective_end_date
458: FROM per_all_assignments_f p
459: ,per_assignment_status_types past
460: WHERE p.business_group_id = g_business_group_id
461: AND p.effective_start_date =
462: (SELECT MAX (p1.effective_start_date)

Line 463: FROM per_all_assignments_f p1

459: ,per_assignment_status_types past
460: WHERE p.business_group_id = g_business_group_id
461: AND p.effective_start_date =
462: (SELECT MAX (p1.effective_start_date)
463: FROM per_all_assignments_f p1
464: ,per_assignment_status_types past1
465: WHERE p1.assignment_id = p.assignment_id
466: AND past1.assignment_status_type_id = p1.assignment_status_type_id
467: AND past1.per_system_status IN ('ACTIVE_ASSIGN' )

Line 477: csr_v_person_id per_all_assignments_f.person_id%TYPE

473:
474: lr_assign_status csr_assign_status%ROWTYPE;
475:
476: CURSOR csr_get_assign_min_start_date (
477: csr_v_person_id per_all_assignments_f.person_id%TYPE
478: ,csr_v_assignment_id per_all_assignments_f.assignment_id%TYPE
479: )
480: IS
481: SELECT MIN (p.effective_start_date) min_date

Line 478: ,csr_v_assignment_id per_all_assignments_f.assignment_id%TYPE

474: lr_assign_status csr_assign_status%ROWTYPE;
475:
476: CURSOR csr_get_assign_min_start_date (
477: csr_v_person_id per_all_assignments_f.person_id%TYPE
478: ,csr_v_assignment_id per_all_assignments_f.assignment_id%TYPE
479: )
480: IS
481: SELECT MIN (p.effective_start_date) min_date
482: FROM per_all_assignments_f p

Line 482: FROM per_all_assignments_f p

478: ,csr_v_assignment_id per_all_assignments_f.assignment_id%TYPE
479: )
480: IS
481: SELECT MIN (p.effective_start_date) min_date
482: FROM per_all_assignments_f p
483: WHERE p.business_group_id = g_business_group_id
484: AND p.person_id = csr_v_person_id
485: AND p.assignment_id = csr_v_assignment_id;
486:

Line 505: ,csr_v_assignment_id per_all_assignments_f.person_id%TYPE

501: lr_person_info csr_person_info%ROWTYPE;
502:
503: CURSOR csr_assignment_info (
504: csr_v_person_id per_all_people_f.person_id%TYPE
505: ,csr_v_assignment_id per_all_assignments_f.person_id%TYPE
506: ,csr_v_effective_date per_all_assignments_f.effective_start_date%TYPE
507: )
508: IS
509: SELECT *

Line 506: ,csr_v_effective_date per_all_assignments_f.effective_start_date%TYPE

502:
503: CURSOR csr_assignment_info (
504: csr_v_person_id per_all_people_f.person_id%TYPE
505: ,csr_v_assignment_id per_all_assignments_f.person_id%TYPE
506: ,csr_v_effective_date per_all_assignments_f.effective_start_date%TYPE
507: )
508: IS
509: SELECT *
510: FROM per_all_assignments_f p

Line 510: FROM per_all_assignments_f p

506: ,csr_v_effective_date per_all_assignments_f.effective_start_date%TYPE
507: )
508: IS
509: SELECT *
510: FROM per_all_assignments_f p
511: WHERE p.business_group_id = g_business_group_id
512: AND p.assignment_id = csr_v_assignment_id
513: AND p.person_id = csr_v_person_id
514: AND csr_v_effective_date BETWEEN p.effective_start_date

Line 520: csr_v_assignment_id per_all_assignments_f.person_id%TYPE

516:
517: lr_assignment_info csr_assignment_info%ROWTYPE;
518:
519: CURSOR csr_extra_assignment_info (
520: csr_v_assignment_id per_all_assignments_f.person_id%TYPE
521: ,csr_v_information_type per_assignment_extra_info.information_type%TYPE
522: )
523: IS
524: SELECT *

Line 532: csr_v_assignment_id per_all_assignments_f.person_id%TYPE

528:
529: lr_extra_assignment_info csr_extra_assignment_info%ROWTYPE;
530:
531: CURSOR csr_se_wtc_time_worked_info (
532: csr_v_assignment_id per_all_assignments_f.person_id%TYPE
533: ,csr_v_year per_assignment_extra_info.aei_information1%TYPE
534: )
535: IS
536: SELECT *