eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_POS_BUS dependencies on PER_ALL_POSITIONS

Line 1435: -- If the POSITION_DEFINITION_ID in PER_ALL_POSITIONS table does not exist

1431: -- p_position_id
1432: -- p_position_definition_id
1433: --
1434: -- Post Success :
1435: -- If the POSITION_DEFINITION_ID in PER_ALL_POSITIONS table does not exist
1436: -- for given BUSINESS_GROUP_ID then processing continues
1437: --
1438: -- Post Failure :
1439: -- If the POSITION_DEFINITION_ID does exist in PER_ALL_POSITIONS table for given

Line 1439: -- If the POSITION_DEFINITION_ID does exist in PER_ALL_POSITIONS table for given

1435: -- If the POSITION_DEFINITION_ID in PER_ALL_POSITIONS table does not exist
1436: -- for given BUSINESS_GROUP_ID then processing continues
1437: --
1438: -- Post Failure :
1439: -- If the POSITION_DEFINITION_ID does exist in PER_ALL_POSITIONS table for given
1440: -- BUSINESS_GROUP_ID, then an application error will be raised and processing
1441: -- terminated
1442: --
1443: -- Access Status :

Line 1585: from per_all_positions posn

1581: l_proc varchar2(72) := g_package||'chk_name_unique_for_BG';
1582: --
1583: cursor csr_name_unique is
1584: select 'x'
1585: from per_all_positions posn
1586: where posn.name = p_name
1587: and (p_position_id is null or posn.position_id <> p_position_id)
1588: and posn.business_group_id = p_business_group_id;
1589: --