APPS.PER_ASSIGNMENTS_F2_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 46: per_assignment_status_types st,

42: ass.primary_flag,
43: ass.special_ceiling_step_id,
44: pb.pay_basis
45: from per_assignments_f ass,
46: per_assignment_status_types st,
47: per_ass_status_type_amends amd,
48: per_pay_bases pb
49: where ass.rowid = P_ROW_ID
50: and ass.assignment_status_type_id =

Line 129: from per_assignment_status_types a,

125: and p.effective_end_date;
126: --
127: cursor asg_type is
128: select 1
129: from per_assignment_status_types a,
130: per_ass_status_type_amends b
131: where b.assignment_status_type_id (+) =
132: a.assignment_status_type_id
133: and a.assignment_status_type_id = P_ASS_ST_TYPE_ID

Line 252: from per_assignment_status_types_tl atl,

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

Line 253: per_assignment_status_types a,

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