APPS.PER_ASSIGNMENTS_F2_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 49: per_assignment_status_types st,

45: ass.special_ceiling_step_id,
46: pb.pay_basis,
47: ass.employment_category --Bug#13960540
48: from per_assignments_f ass,
49: per_assignment_status_types st,
50: per_ass_status_type_amends amd,
51: per_pay_bases pb
52: where ass.rowid = P_ROW_ID
53: and ass.assignment_status_type_id =

Line 133: from per_assignment_status_types a,

129: and p.effective_end_date;
130: --
131: cursor asg_type is
132: select 1
133: from per_assignment_status_types a,
134: per_ass_status_type_amends b
135: where b.assignment_status_type_id (+) =
136: a.assignment_status_type_id
137: and a.assignment_status_type_id = P_ASS_ST_TYPE_ID

Line 256: from per_assignment_status_types_tl atl,

252: -- 923011: Ensure user status is in the appropriate language
253: cursor def_assgt_status is
254: select nvl(btl.user_status,atl.user_status),
255: a.assignment_status_type_id
256: from per_assignment_status_types_tl atl,
257: per_assignment_status_types a,
258: per_ass_status_type_amends_tl btl,
259: per_ass_status_type_amends b
260: where atl.assignment_status_type_id = a.assignment_status_type_id

Line 257: per_assignment_status_types a,

253: cursor def_assgt_status is
254: select nvl(btl.user_status,atl.user_status),
255: a.assignment_status_type_id
256: from per_assignment_status_types_tl atl,
257: per_assignment_status_types a,
258: per_ass_status_type_amends_tl btl,
259: per_ass_status_type_amends b
260: where atl.assignment_status_type_id = a.assignment_status_type_id
261: and atl.language = userenv('LANG')