DBA Data[Home] [Help]

APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 6072: from per_assignment_status_types s,

6068: -- pabodla : mapping data
6069: --
6070: cursor c_get_mapping_name4(p_id in number) is
6071: select nvl(atl.user_status, stl.user_status) dsp_meaning
6072: from per_assignment_status_types s,
6073: per_ass_status_type_amends a ,
6074: per_business_groups bus ,
6075: per_assignment_status_types_tl stl ,
6076: per_ass_status_type_amends_tl atl

Line 6075: per_assignment_status_types_tl stl ,

6071: select nvl(atl.user_status, stl.user_status) dsp_meaning
6072: from per_assignment_status_types s,
6073: per_ass_status_type_amends a ,
6074: per_business_groups bus ,
6075: per_assignment_status_types_tl stl ,
6076: per_ass_status_type_amends_tl atl
6077: where a.assignment_status_type_id (+) = s.assignment_status_type_id
6078: and a.business_group_id (+) = p_business_group_id
6079: and nvl(s.business_group_id, p_business_group_id) = p_business_group_id