APPS.PAY_US_MMREF_REPORTING1 dependencies on FF_USER_ENTITIES

Line 41: ff_user_entities UE

37: -- Get the defined_balance_id for the specified balance DB item.
38: CURSOR csr_defined_balance IS
39: SELECT TO_NUMBER(UE.creator_id)
40: FROM ff_database_items DI,
41: ff_user_entities UE
42: WHERE DI.user_name = p_db_item_name
43: AND UE.user_entity_id = DI.user_entity_id
44: AND UE.creator_type = 'B'
45: AND UE.legislation_code = 'US'; /* Bug:2296797 */

Line 233: SELECT user_entity_id from ff_user_entities

229: -- Cursor to fetch people in a given GRE with earnings in the given state to
230:
231: CURSOR c_tax_ein
232: IS
233: SELECT user_entity_id from ff_user_entities
234: WHERE user_entity_name = 'A_TAX_UNIT_EMPLOYER_IDENTIFICATION_NUMBER';
235:
236:
237:

Line 1434: FROM ff_user_entities

1430: l_jurisdiction varchar2(80);
1431:
1432: CURSOR c_state_sit IS
1433: SELECT user_entity_id
1434: FROM ff_user_entities
1435: WHERE user_entity_name = 'A_STATE_TAX_RULES_ORG_SIT_COMPANY_STATE_ID';
1436:
1437: CURSOR c_get_state_id
1438: IS

Line 1694: FROM ff_user_entities

1690: --
1691: --
1692: CURSOR c_get_user_entity_id IS
1693: SELECT user_entity_id
1694: FROM ff_user_entities
1695: WHERE user_entity_name = 'A_LC_FEDERAL_TAX_RULES_ORG_GOVERNMENT_EMPLOYER';
1696:
1697:
1698: CURSOR c_chk_for_govt_employer (p_user_entity_id NUMBER) IS