APPS.PER_ASSIGNMENTS_F2_PKG dependencies on PER_ASS_STATUS_TYPE_AMENDS

Line 47: per_ass_status_type_amends amd,

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 =
51: amd.assignment_status_type_id (+)

Line 130: per_ass_status_type_amends b

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
134: and b.business_group_id (+) + 0 = P_BG_ID

Line 254: per_ass_status_type_amends_tl btl,

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')
258: and btl.ass_status_type_amend_id (+) = b.ass_status_type_amend_id

Line 255: per_ass_status_type_amends b

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')
258: and btl.ass_status_type_amend_id (+) = b.ass_status_type_amend_id
259: and btl.language (+) = userenv('LANG')