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.PER_APPLICATIONS_PKG dependencies on PER_ASSIGNMENTS_F

Line 28: FROM per_assignments_f a

24: p_date_end DATE) return NUMBER IS
25:
26: CURSOR c_get_ass_type IS
27: SELECT a.assignment_status_type_id
28: FROM per_assignments_f a
29: WHERE a.person_id = p_person_id
30: AND A.business_group_id + 0 = p_business_group_id
31: AND A.APPLICATION_ID = p_application_id
32: AND p_date_end between A.EFFECTIVE_START_DATE

Line 392: FROM per_assignments_f A

388: AND l.business_group_id + 0 = p_business_group_id
389: AND l.assignment_status_type_id = P_dummy_asg_stat_id
390: AND EXISTS
391: (SELECT NULL
392: FROM per_assignments_f A
393: WHERE a.business_group_id + 0 = p_business_group_id
394: AND a.person_id = p_person_id
395: AND a.assignment_status_type_id = P_dummy_asg_stat_id
396: AND a.assignment_type = 'A'

Line 525: FROM PER_ASSIGNMENTS_f

521: = 'AUTO');
522:
523: CURSOR csr_assign IS
524: SELECT ASSIGNMENT_ID
525: FROM PER_ASSIGNMENTS_f
526: WHERE business_group_id + 0 = p_business_group_id
527: AND PERSON_ID = p_person_id
528: AND APPLICATION_ID = p_application_id
529: AND ASSIGNMENT_TYPE = 'A'

Line 551: v_assignment_id per_assignments_f.assignment_id%TYPE;

547: v_dummy_asg_id NUMBER(1);
548: v_letter_request_id NUMBER(15);
549: v_test_new_req NUMBER(1);
550: v_letter_type NUMBER(15);
551: v_assignment_id per_assignments_f.assignment_id%TYPE;
552: l_dummy_number number; -- Added for bug 3680947.
553:
554: --
555:

Line 762: , per_assignments_f a

758:
759: CURSOR c_chk_lines IS
760: SELECT distinct(1)
761: FROM per_letter_request_lines L
762: , per_assignments_f a
763: WHERE l.person_id = P_person_id
764: AND l.business_group_id + 0 = p_business_group_id
765: AND l.assignment_id = a.assignment_id
766: AND a.person_id = P_person_id

Line 835: FROM per_assignments_f a

831: AND lrl.person_id = P_person_id
832: AND lrl.person_id = P_person_id
833: AND EXISTS
834: (SELECT NULL
835: FROM per_assignments_f a
836: WHERE a.assignment_id = lrl.assignment_id
837: AND a.person_id = P_person_id
838: AND a.application_id = p_application_id
839: AND a.business_group_id + 0 = P_business_group_id);

Line 949: , per_assignments_f asg

945:
946: CURSOR c_chk_prv_status IS
947: select 1
948: from per_assignment_status_types t
949: , per_assignments_f asg
950: where asg.person_id = p_person_id
951: and nvl(t.business_group_id,
952: p_business_group_id) = p_business_group_id
953: and t.PER_SYSTEM_STATUS = 'TERM_APL'

Line 1051: , per_assignments_f asg

1047:
1048: CURSOR c_chk_prv_status IS
1049: select 1
1050: from per_assignment_status_types t
1051: , per_assignments_f asg
1052: where asg.person_id = p_person_id
1053: and nvl(t.business_group_id,
1054: p_business_group_id) = p_business_group_id
1055: and t.PER_SYSTEM_STATUS = 'TERM_APL'

Line 1423: from per_assignments_f paf

1419: and s.end_date = p_end_date
1420: and sa.assignment_id = s.assignment_id
1421: and exists
1422: (select null
1423: from per_assignments_f paf
1424: where paf.person_id = p_person_id
1425: and paf.application_id = p_application_id
1426: and paf.assignment_type = 'A'
1427: and paf.effective_end_date = p_end_date

Line 1475: ,per_assignments_f a

1471: -- This was achieved by removing the sub-query
1472: cursor chk_sec_stat is
1473: select 1
1474: from per_secondary_ass_statuses s
1475: ,per_assignments_f a
1476: where s.business_group_id + 0 = p_business_group_id
1477: and s.start_date is not null
1478: and a.business_group_id + 0 = p_business_group_id
1479: and a.person_id = p_person_id

Line 1493: ,per_assignments_f paf

1489: -- This was achieved by removing the sub-query
1490: cursor c_sec_stat is
1491: select sa.assignment_id
1492: from per_secondary_ass_statuses sa
1493: ,per_assignments_f paf
1494: where sa.business_group_id + 0 = p_business_group_id
1495: and sa.start_date <= p_end_date
1496: and (sa.end_date is null
1497: or sa.end_date > p_end_date)

Line 1522: from per_assignments_f a

1518: where s.business_group_id + 0 = p_business_group_id
1519: and trunc(s.start_date) > p_end_date
1520: and s.assignment_id in
1521: (select a.assignment_id
1522: from per_assignments_f a
1523: where a.business_group_id + 0 = p_business_group_id
1524: and a.person_id = p_person_id
1525: and a.application_id = p_application_id
1526: and a.assignment_type = 'A'

Line 1566: , PER_ASSIGNMENTS_F A

1562: P_application_id NUMBER) IS
1563: CURSOR chk_events IS
1564: SELECT E.EVENT_ID
1565: FROM PER_EVENTS E
1566: , PER_ASSIGNMENTS_F A
1567: WHERE A.PERSON_ID = P_person_id
1568: AND E.business_group_id + 0 = p_business_group_id
1569: AND A.business_group_id + 0 = p_business_group_id
1570: AND A.APPLICATION_ID = P_application_id

Line 1580: , PER_ASSIGNMENTS_F A

1576: CURSOR chk_bookings IS
1577: SELECT distinct(1)
1578: FROM PER_BOOKINGS B
1579: , PER_EVENTS E
1580: , PER_ASSIGNMENTS_F A
1581: WHERE A.PERSON_ID = P_person_id
1582: AND A.APPLICATION_ID = P_application_id
1583: AND B.EVENT_ID = E.EVENT_ID
1584: AND E.DATE_START >= P_date_end