DBA Data[Home] [Help]

APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on PER_BUSINESS_GROUPS

Line 1840: per_business_groups bus ,

1836: cursor c_get_mapping_name1(p_id in number) is
1837: select nvl(atl.user_status, stl.user_status) dsp_meaning
1838: from per_assignment_status_types s,
1839: per_ass_status_type_amends a ,
1840: per_business_groups bus ,
1841: per_assignment_status_types_tl stl ,
1842: per_ass_status_type_amends_tl atl
1843: where a.assignment_status_type_id (+) = s.assignment_status_type_id
1844: and a.business_group_id (+) = p_business_group_id