DBA Data[Home] [Help]

APPS.BEN_BENLESUM_XMLP_PKG dependencies on DUAL

Line 25: select hr_general.decode_organization(p_organization_id),hr_general.decode_location(p_location_id),hr_general.decode_organization(p_business_group_id) from dual;

21: cursor c_ler_type is
22: Select meaning from hr_lookups where lookup_type = 'BEN_LESUM_LER_TYPE' and lookup_code = p_ler_type;
23:
24: cursor c_BG_info is
25: select hr_general.decode_organization(p_organization_id),hr_general.decode_location(p_location_id),hr_general.decode_organization(p_business_group_id) from dual;
26:
27: cursor c_benefit_group_name is
28: Select name from BEN_BENFTS_GRP where benfts_grp_id=p_benefit_group_id and business_group_id=p_business_group_id;
29: