APPS.PAY_US_SQWL_ARCHIVE dependencies on FF_USER_ENTITIES

Line 346: from ff_user_entities UE,

342: /* Get the defined_balance_id for the specified balance DB item. */
343:
344: cursor csr_defined_balance is
345: select fnd_number.canonical_to_number(UE.creator_id)
346: from ff_user_entities UE,
347: ff_database_items DI
348: where DI.user_name = p_db_item_name
349: and UE.user_entity_id = DI.user_entity_id
350: and Ue.creator_type = 'B'

Line 3554: l_user_entity_id ff_user_entities.user_entity_id%type;

3550: AND ASG.Effective_end_date)
3551: ORDER BY ASG.effective_start_date desc ;
3552:
3553: l_location_id per_all_assignments_f.location_id%type;
3554: l_user_entity_id ff_user_entities.user_entity_id%type;
3555: l_archive_item_id ff_archive_items.archive_item_id%type;
3556: l_object_version_number ff_archive_items.object_version_number%type;
3557: l_some_warning boolean;
3558:

Line 3648: FROM ff_user_entities

3644: -- set the correct user_entity_id for the archive call
3645: BEGIN
3646: SELECT user_entity_id
3647: INTO l_user_entity_id
3648: FROM ff_user_entities
3649: WHERE user_entity_name = 'A_SQWL_LOC_MON_' || to_char(i);
3650: EXCEPTION
3651: WHEN NO_DATA_FOUND THEN
3652: hr_utility.trace('User entities SQWL_LOC_MON_* not define contact your system administrator');

Line 3700: FROM ff_user_entities

3696: -- set the correct user_entity_id for the archive call
3697: BEGIN
3698: SELECT user_entity_id
3699: INTO l_user_entity_id
3700: FROM ff_user_entities
3701: WHERE user_entity_name = 'A_SQWL_LOC_QTR_END';
3702: EXCEPTION
3703: WHEN NO_DATA_FOUND THEN
3704: hr_utility.trace('User entities A_SQWL_LOC_END_QTR not define contact your system administrator');