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_ASSIGNMENT_STATUS_TYPES

Line 753: , per_assignment_status_types a

749:
750: CURSOR c_term_apl_stat IS
751: SELECT 1
752: FROM per_letter_gen_statuses s
753: , per_assignment_status_types a
754: WHERE s.business_group_id + 0 = p_business_group_id
755: AND a.assignment_status_type_id = s.assignment_status_type_id
756: AND a.per_system_status = 'TERM_APL'
757: AND s.enabled_flag = 'Y';

Line 775: PER_ASSIGNMENT_STATUS_TYPES T

771: CURSOR csr_let_req_id IS
772: SELECT r.letter_request_id
773: FROM PER_LETTER_REQUESTS R,
774: PER_LETTER_GEN_STATUSES s,
775: PER_ASSIGNMENT_STATUS_TYPES T
776: WHERE r.business_group_id + 0 = p_business_group_id
777: AND s.business_group_id + 0 = p_business_group_id
778: AND r.LETTER_TYPE_ID = S.LETTER_TYPE_ID
779: AND s.ASSIGNMENT_STATUS_TYPE_ID = T.ASSIGNMENT_STATUS_TYPE_ID

Line 789: PER_ASSIGNMENT_STATUS_TYPES T

785: CURSOR csr_odd_reqs IS
786: SELECT R.LETTER_REQUEST_ID
787: FROM PER_LETTER_REQUESTS R,
788: PER_LETTER_GEN_STATUSES s,
789: PER_ASSIGNMENT_STATUS_TYPES T
790: WHERE r.business_group_id + 0 = p_business_group_id
791: AND s.business_group_id + 0 = p_business_group_id
792: AND r.LETTER_TYPE_ID = S.LETTER_TYPE_ID
793: AND s.ASSIGNMENT_STATUS_TYPE_ID = T.ASSIGNMENT_STATUS_TYPE_ID

Line 948: from per_assignment_status_types t

944: p_last_update_login NUMBER) IS
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

Line 963: FROM per_assignment_status_types a

959:
960: --
961: CURSOR get_actve_apl IS
962: SELECT a.assignment_status_type_id
963: FROM per_assignment_status_types a
964: , per_ass_status_type_amends b
965: WHERE a.per_system_status = 'ACTIVE_APL'
966: AND b.assignment_status_type_id(+) = a.assignment_status_type_id
967: AND b.business_group_id(+) + 0 = p_business_group_id

Line 1050: from per_assignment_status_types t

1046: p_assignment_id NUMBER) IS
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

Line 1065: FROM per_assignment_status_types a

1061:
1062: --
1063: CURSOR get_actve_apl IS
1064: SELECT a.assignment_status_type_id
1065: FROM per_assignment_status_types a
1066: , per_ass_status_type_amends b
1067: WHERE a.per_system_status = 'ACTIVE_APL'
1068: AND b.assignment_status_type_id(+) = a.assignment_status_type_id
1069: AND b.business_group_id(+) + 0 = p_business_group_id

Line 2418: ,per_assignment_status_types ast

2414: SELECT asg.assignment_id
2415: ,asg.effective_start_date
2416: ,asg.effective_end_date
2417: FROM per_all_assignments_f asg
2418: ,per_assignment_status_types ast
2419: WHERE asg.effective_start_date > p_date_end
2420: AND asg.person_id = p_person_id
2421: AND asg.application_id = p_application_id
2422: AND asg.assignment_status_type_id = ast.assignment_status_type_id

Line 2794: l_ass_status per_assignment_status_types.per_system_status%Type;

2790: p_action varchar2) is
2791: --
2792: l_assignment_id per_all_assignments_f.assignment_id%Type;
2793: l_irc_ass_status_id irc_assignment_statuses.assignment_status_id%Type;
2794: l_ass_status per_assignment_status_types.per_system_status%Type;
2795: l_irc_asg_status_ovn irc_assignment_statuses.object_version_number%Type;
2796: l_ass_status_type_id per_all_assignments_f.assignment_status_type_id%Type;
2797: --
2798: -- To get the assignment status based o the action (Termination or

Line 2802: from per_assignment_status_types a,

2798: -- To get the assignment status based o the action (Termination or
2799: -- Reverse termination)
2800: cursor csr_get_asg_status is
2801: select a.assignment_status_type_id
2802: from per_assignment_status_types a,
2803: per_ass_status_type_amends b
2804: where a.per_system_status = l_ass_status
2805: and b.assignment_status_type_id(+) = a.assignment_status_type_id
2806: and b.business_group_id(+) + 0 = p_business_group_id