APPS.HRI_PARAMETERS dependencies on PER_BUSINESS_GROUPS

Line 1187: from per_business_groups b , fnd_currencies_vl c

1183: -- Parameter Request String : CURRCD
1184:
1185: cursor c_currcd is
1186: select c.currency_code , c.name
1187: from per_business_groups b , fnd_currencies_vl c
1188: where b.business_group_id = hr_bis.get_sec_profile_bg_id -- bug 2968520
1189: and c.enabled_flag = 'Y'
1190: and sysdate between nvl(c.start_date_active, hr_general.start_of_time)
1191: and nvl(c.end_date_active, hr_general.end_of_time)

Line 1670: from fnd_new_messages , per_business_groups

1666: and message_name in ('HR_BIS_GRADE', 'HR_BIS_PERFORMANCE_RATING', 'HR_BIS_SERVICE_BAND',
1667: 'HR_BIS_JOB', 'HR_BIS_LOCATION', 'HR_BIS_GENDER')
1668: UNION
1669: select message_name , message_text
1670: from fnd_new_messages , per_business_groups
1671: where business_group_id = hr_bis.get_sec_profile_bg_id -- bug 2968520
1672: and legislation_code = 'US'
1673: and language_code = userenv('LANG')
1674: and application_id = 453

Line 1678: from fnd_new_messages fnm , per_business_groups bus

1674: and application_id = 453
1675: and message_name = 'HR_BIS_EEO_CATEGORY'
1676: UNION
1677: select message_name , message_text
1678: from fnd_new_messages fnm , per_business_groups bus
1679: where bus.business_group_id = hr_bis.get_sec_profile_bg_id -- bug 2968520
1680: and language_code = userenv('LANG')
1681: and application_id = 453
1682: and legislation_code <> 'US'