APPS.PER_LETTER_GEN_STATUSES_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES_TL

Line 73: from per_assignment_status_types_tl ttl,

69: --cursor c1 is select assignment_status
70: --from assignment_status_lov
71: --where p_assignment_status_type_id = assignment_status_type_id;
72: cursor c1 is select nvl(atl.user_status, ttl.user_status)
73: from per_assignment_status_types_tl ttl,
74: per_assignment_status_types t,
75: per_ass_status_type_amends_tl atl,
76: per_ass_status_type_amends a
77: where t.assignment_status_type_id = p_assignment_status_type_id