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 2442: l_ass_status per_assignment_status_types.per_system_status%Type;

2438: p_action varchar2) is
2439: --
2440: l_assignment_id per_all_assignments_f.assignment_id%Type;
2441: l_irc_ass_status_id irc_assignment_statuses.assignment_status_id%Type;
2442: l_ass_status per_assignment_status_types.per_system_status%Type;
2443: l_irc_asg_status_ovn irc_assignment_statuses.object_version_number%Type;
2444: l_ass_status_type_id per_all_assignments_f.assignment_status_type_id%Type;
2445: --
2446: -- To get the assignment status based o the action (Termination or

Line 2450: from per_assignment_status_types a,

2446: -- To get the assignment status based o the action (Termination or
2447: -- Reverse termination)
2448: cursor csr_get_asg_status is
2449: select a.assignment_status_type_id
2450: from per_assignment_status_types a,
2451: per_ass_status_type_amends b
2452: where a.per_system_status = l_ass_status
2453: and b.assignment_status_type_id(+) = a.assignment_status_type_id
2454: and b.business_group_id(+) + 0 = p_business_group_id