DBA Data[Home] [Help]

APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on PER_ASS_STATUS_TYPE_AMENDS

Line 6073: per_ass_status_type_amends a ,

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
6077: where a.assignment_status_type_id (+) = s.assignment_status_type_id

Line 6076: per_ass_status_type_amends_tl atl

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
6080: and nvl(s.legislation_code, bus.legislation_code) = bus.legislation_code