DBA Data[Home] [Help]

APPS.PER_MM_ASSIGNMENTS_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 74: per_assignment_status_types stat,

70: gra.grade_id,
71: to_number(scl.segment1)
72: from per_assignments_f asg,
73: per_mm_positions mmpos,
74: per_assignment_status_types stat,
75: hr_soft_coding_keyflex scl,
76: per_grades gra
77: where asg.position_id = mmpos.position_id
78: and mmpos.mass_move_id = p_mass_move_id

Line 117: per_assignment_status_types stat,

113: gra.grade_id,
114: null
115: from per_assignments_f asg,
116: per_mm_positions mmpos,
117: per_assignment_status_types stat,
118: per_grades gra
119: where asg.position_id = mmpos.position_id
120: and mmpos.mass_move_id = p_mass_move_id
121: and p_session_date between