DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_TXNS_API dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1347: from per_assignment_status_types s,

1343: --
1344: cursor c_EmployeeStatusLovVO(p_source_name1 varchar2) is
1345: select nvl(atl.user_status, stl.user_status) name
1346: , s.assignment_status_type_id id
1347: from per_assignment_status_types s,
1348: per_ass_status_type_amends a,
1349: per_assignment_status_types_tl stl,
1350: per_ass_status_type_amends_tl atl
1351: where a.assignment_status_type_id (+) = s.assignment_status_type_id

Line 1349: per_assignment_status_types_tl stl,

1345: select nvl(atl.user_status, stl.user_status) name
1346: , s.assignment_status_type_id id
1347: from per_assignment_status_types s,
1348: per_ass_status_type_amends a,
1349: per_assignment_status_types_tl stl,
1350: per_ass_status_type_amends_tl atl
1351: where a.assignment_status_type_id (+) = s.assignment_status_type_id
1352: and a.business_group_id (+) = p_target_business_group_id
1353: and nvl(s.business_group_id, p_target_business_group_id) = p_target_business_group_id