APPS.PAY_NO_SAL_STATISTICS_ARCHIVE dependencies on FF_USER_ENTITIES

Line 445: FROM ff_user_entities u,

441: IS
442: /* Cursor to retrieve Defined Balance Id */
443: CURSOR csr_def_bal_id(p_user_name VARCHAR2) IS
444: SELECT u.creator_id
445: FROM ff_user_entities u,
446: ff_database_items d
447: WHERE d.user_name = p_user_name
448: AND u.user_entity_id = d.user_entity_id
449: AND (u.legislation_code = 'NO' )

Line 452: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;

448: AND u.user_entity_id = d.user_entity_id
449: AND (u.legislation_code = 'NO' )
450: AND (u.business_group_id IS NULL )
451: AND u.creator_type = 'B';
452: l_defined_balance_id ff_user_entities.user_entity_id%TYPE;
453:
454: BEGIN
455: IF g_debug THEN
456: hr_utility.set_location(' Entering Function GET_DEFINED_BALANCE_ID',240);