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 449: csr_v_person_id per_all_assignments_f.person_id%TYPE

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

Line 450: ,csr_v_assignment_id per_all_assignments_f.assignment_id%TYPE

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

Line 456: FROM per_all_assignments_f p

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

Line 461: FROM per_all_assignments_f p1

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

Line 475: csr_v_person_id per_all_assignments_f.person_id%TYPE

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

Line 476: ,csr_v_assignment_id per_all_assignments_f.assignment_id%TYPE

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

Line 480: FROM per_all_assignments_f p

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

Line 503: ,csr_v_assignment_id per_all_assignments_f.person_id%TYPE

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

Line 504: ,csr_v_effective_date per_all_assignments_f.effective_start_date%TYPE

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

Line 508: FROM per_all_assignments_f p

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

Line 518: csr_v_assignment_id per_all_assignments_f.person_id%TYPE

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

Line 530: csr_v_assignment_id per_all_assignments_f.person_id%TYPE

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