APPS.PQP_GB_PSI_SERVICE_HISTORY dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 697: p_per_system_status IN per_assignment_status_types.per_system_status%TYPE

693: -- ----------------------------------------------------------------------------
694: -- |----------------------< get_asg_status_type >-----------------------------|
695: -- ----------------------------------------------------------------------------
696: PROCEDURE get_asg_status_type(
697: p_per_system_status IN per_assignment_status_types.per_system_status%TYPE
698: ,p_rec_asg_sts_dtls OUT NOCOPY csr_get_asg_sts_dtls%ROWTYPE
699: )
700: IS
701: --

Line 758: RETURN per_assignment_status_types.user_status%TYPE

754: -- ----------------------------------------------------------------------------
755: -- |----------------------< get_asg_status_type >-----------------------------|
756: -- ----------------------------------------------------------------------------
757: FUNCTION get_asg_status_type(p_asg_sts_type_id IN NUMBER)
758: RETURN per_assignment_status_types.user_status%TYPE
759: IS
760: --
761: CURSOR csr_get_asg_sts_dtls
762: IS

Line 764: FROM per_assignment_status_types

760: --
761: CURSOR csr_get_asg_sts_dtls
762: IS
763: SELECT user_status
764: FROM per_assignment_status_types
765: WHERE assignment_status_type_id = p_asg_sts_type_id;
766:
767: l_proc_name VARCHAR2(80) := g_proc_name || 'get_asg_status_type';
768: l_proc_step PLS_INTEGER;

Line 769: l_user_status per_assignment_status_types.user_status%TYPE;

765: WHERE assignment_status_type_id = p_asg_sts_type_id;
766:
767: l_proc_name VARCHAR2(80) := g_proc_name || 'get_asg_status_type';
768: l_proc_step PLS_INTEGER;
769: l_user_status per_assignment_status_types.user_status%TYPE;
770: --
771: BEGIN
772: --
773: IF g_debug

Line 1007: l_asg_status per_assignment_status_types.user_status%TYPE;

1003: l_ret_break VARCHAR2(10);
1004: l_meaning hr_lookups.meaning%TYPE;
1005: l_configuration_desc fnd_descr_flex_contexts_vl.descriptive_flex_context_name%TYPE;
1006: l_abs_type_name per_absence_attendance_types.NAME%TYPE;
1007: l_asg_status per_assignment_status_types.user_status%TYPE;
1008: l_miss_events VARCHAR2(32000);
1009: --
1010: BEGIN
1011: --

Line 5183: per_assignment_status_types past

5179: IS
5180: SELECT effective_end_date
5181: FROM per_all_assignments_f paaf,
5182: per_periods_of_service pps,
5183: per_assignment_status_types past
5184: WHERE paaf.assignment_id = p_assignment_id
5185: AND paaf.assignment_status_type_id = past.assignment_status_type_id
5186: and pps.person_id = paaf.person_id
5187: and pps.period_of_service_id = paaf.period_of_service_id