DBA Data[Home] [Help]

APPS.PAY_KW_ARCHIVE dependencies on FF_USER_ENTITIES

Line 1458: FROM ff_user_entities u,

1454: IS
1455: /* Cursor to retrieve Defined Balance Id */
1456: CURSOR csr_def_bal_id(p_user_name VARCHAR2) IS
1457: SELECT u.creator_id
1458: FROM ff_user_entities u,
1459: ff_database_items d
1460: WHERE d.user_name = p_user_name
1461: AND u.user_entity_id = d.user_entity_id
1462: AND (u.legislation_code = 'KW' )

Line 1466: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;

1462: AND (u.legislation_code = 'KW' )
1463: AND (u.business_group_id IS NULL )
1464: AND u.creator_type = 'B';
1465:
1466: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
1467:
1468: BEGIN
1469: IF g_debug THEN
1470: hr_utility.set_location(' Entering Function GET_DEFINED_BALANCE_ID',240);