APPS.HRI_PARAMETERS dependencies on FND_NEW_MESSAGES

Line 706: from fnd_new_messages

702:
703: cursor c_geog_level is
704: select '1' lev_code,
705: message_text lev
706: from fnd_new_messages
707: where message_name = 'HR_BIS_AREA'
708: and application_id = 453
709: and language_code = userenv('LANG')
710: union

Line 713: from fnd_new_messages

709: and language_code = userenv('LANG')
710: union
711: select '2' lev_code,
712: message_text lev
713: from fnd_new_messages
714: where message_name = 'HR_BIS_COUNTRY'
715: and application_id = 453
716: and language_code = userenv('LANG')
717: union

Line 720: from fnd_new_messages

716: and language_code = userenv('LANG')
717: union
718: select '3' lev_code,
719: message_text lev
720: from fnd_new_messages
721: where message_name = 'HR_BIS_REGION'
722: and application_id = 453
723: and language_code = userenv('LANG');
724:

Line 1285: from fnd_new_messages

1281: -- Parameter Request String : EXCCUR
1282:
1283: cursor c_exccur is
1284: select message_name , message_text
1285: from fnd_new_messages
1286: where message_name in ('HR_BIS_INCLUDE','HR_BIS_EXCLUDE')
1287: and language_code = userenv('LANG')
1288: and application_id = 453
1289: order by decode(message_name,'HR_BIS_EXCLUDE','1,2');

Line 1663: from fnd_new_messages

1659: -- p_option - determines which set of view by options appears
1660:
1661: cursor c_viewby1 is
1662: select message_name , message_text
1663: from fnd_new_messages
1664: where language_code = userenv('LANG')
1665: and application_id = 453
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')

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'

Line 1687: from fnd_new_messages

1683: and message_name = 'HR_BIS_ETHNIC_ORIGIN' order by 2;
1684:
1685: cursor c_viewby2 is
1686: select message_name , message_text
1687: from fnd_new_messages
1688: where language_code = userenv('LANG')
1689: and application_id = 453
1690: and message_name in ('HR_BIS_AGE_YEARS', 'HR_BIS_LOS_YEARS', 'HR_BIS_GRADE', 'HR_BIS_PERFORMANCE_RATING')
1691: order by message_name;

Line 1696: from fnd_new_messages

1692:
1693: cursor c_viewby3 is
1694: select message_name,
1695: message_text
1696: from fnd_new_messages
1697: where message_name IN ('HR_BIS_TIME', 'HR_BIS_GEOGRAPHY', 'HR_BIS_PRODUCT')
1698: and application_id = 453
1699: and language_code = userenv('LANG')
1700: order by 1 desc;