DBA Data[Home] [Help]

APPS.PAY_US_MMREF_LOCAL dependencies on FF_USER_ENTITIES

Line 74: ff_user_entities UE

70: -- Get the defined_balance_id for the specified balance DB item.
71: CURSOR csr_defined_balance IS
72: SELECT TO_NUMBER(UE.creator_id)
73: FROM ff_database_items DI,
74: ff_user_entities UE
75: WHERE DI.user_name = p_db_item_name
76: AND UE.user_entity_id = DI.user_entity_id
77: AND UE.creator_type = 'B'
78: AND UE.legislation_code = 'US'; /* Bug:2296797 */

Line 277: SELECT user_entity_id from ff_user_entities

273: -- Cursor to fetch people in a given GRE with earnings in the given state to
274:
275: CURSOR c_tax_ein
276: IS
277: SELECT user_entity_id from ff_user_entities
278: WHERE user_entity_name = 'A_TAX_UNIT_EMPLOYER_IDENTIFICATION_NUMBER';
279:
280:
281:

Line 1341: FROM ff_user_entities

1337: l_jurisdiction varchar2(80);
1338:
1339: CURSOR c_state_sit IS
1340: SELECT user_entity_id
1341: FROM ff_user_entities
1342: WHERE user_entity_name = 'A_STATE_TAX_RULES_ORG_SIT_COMPANY_STATE_ID';
1343:
1344: CURSOR c_get_state_id
1345: IS