DBA Data[Home] [Help]

APPS.PAY_US_REPORTING_UTILS_PKG dependencies on FF_USER_ENTITIES

Line 2320: ff_user_entities fue

2316: CURSOR get_user_entity_id
2317: (c_user_name ff_database_items.user_name%type) IS
2318: SELECT fdi.user_entity_id
2319: FROM ff_database_items fdi,
2320: ff_user_entities fue
2321: WHERE fue.legislation_code = 'US'
2322: AND fue.user_entity_id = fdi.user_entity_id
2323: AND fdi.user_name = c_user_name;
2324:

Line 2797: FROM ff_user_entities UE,

2793: /* Get the defined_balance_id for the specified balance DB item. */
2794:
2795: CURSOR csr_defined_balance is
2796: SELECT to_number(UE.creator_id)
2797: FROM ff_user_entities UE,
2798: ff_database_items DI
2799: WHERE DI.user_name = p_db_item_name
2800: AND UE.user_entity_id = DI.user_entity_id
2801: AND Ue.creator_type = 'B'