APPS.PQH_FR_EMP_STAT_SITUATION_API dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 43: per_assignment_status_types ast

39: ast.per_system_status,
40: ast.pay_system_status,
41: asg.object_version_number
42: FROM per_all_assignments_f asg,
43: per_assignment_status_types ast
44: WHERE asg.person_id = p_person_id
45: AND p_eff_date BETWEEN asg.effective_start_date AND asg.effective_end_date
46: AND asg.primary_flag = 'Y'
47: AND asg.assignment_status_type_id = ast.assignment_status_type_id;

Line 58: per_assignment_status_types ast

54: assignment_type,
55: asg.object_version_number
56: FROM per_all_assignments_f asg,
57: hr_soft_coding_keyflex scl,
58: per_assignment_status_types ast
59: WHERE asg.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
60: AND scl.segment26 = p_career_id
61: AND asg.assignment_status_type_id = ast.assignment_status_type_id
62: AND ast.per_system_status = p_per_status

Line 72: per_assignment_status_types ast

68: CURSOR csr_invalid_term_assign(p_affect_asg_id IN NUMBER,
69: p_term_st_dt IN DATE) IS
70: SELECT 'Y'
71: FROM per_all_assignments_f asg,
72: per_assignment_status_types ast
73: where asg.assignment_id = p_affect_asg_id
74: and asg.effective_end_date >= p_term_st_dt
75: and ast.assignment_status_type_id = asg.assignment_status_type_id
76: and ast.per_system_status = 'TERM_ASSIGN';