APPS.PAY_US_MMREF_REPORTING dependencies on FF_USER_ENTITIES

Line 143: ff_user_entities UE

139: -- Get the defined_balance_id for the specified balance DB item.
140: CURSOR csr_defined_balance IS
141: SELECT TO_NUMBER(UE.creator_id)
142: FROM ff_database_items DI,
143: ff_user_entities UE
144: WHERE DI.user_name = p_db_item_name
145: AND UE.user_entity_id = DI.user_entity_id
146: AND UE.creator_type = 'B'
147: AND UE.legislation_code = 'US'; /* Bug:2296797 */

Line 335: SELECT user_entity_id from ff_user_entities

331: -- Cursor to fetch people in a given GRE with earnings in the given state to
332:
333: CURSOR c_tax_ein
334: IS
335: SELECT user_entity_id from ff_user_entities
336: WHERE user_entity_name = 'A_TAX_UNIT_EMPLOYER_IDENTIFICATION_NUMBER';
337:
338:
339:

Line 1922: FROM ff_user_entities

1918: l_jurisdiction varchar2(80);
1919:
1920: CURSOR c_state_sit IS
1921: SELECT user_entity_id
1922: FROM ff_user_entities
1923: WHERE user_entity_name = 'A_STATE_TAX_RULES_ORG_SIT_COMPANY_STATE_ID';
1924:
1925: CURSOR c_get_state_id
1926: IS

Line 2182: FROM ff_user_entities

2178: --
2179: --
2180: CURSOR c_get_user_entity_id IS
2181: SELECT user_entity_id
2182: FROM ff_user_entities
2183: WHERE user_entity_name = 'A_LC_FEDERAL_TAX_RULES_ORG_GOVERNMENT_EMPLOYER';
2184:
2185:
2186: CURSOR c_chk_for_govt_employer (p_user_entity_id NUMBER) IS

Line 2269: FROM ff_user_entities

2265: l_ue_id NUMBER;
2266: --
2267: CURSOR c_get_user_entity_id IS
2268: SELECT user_entity_id
2269: FROM ff_user_entities
2270: WHERE user_entity_name = 'A_LC_FEDERAL_TAX_RULES_ORG_GOVERNMENT_EMPLOYER';
2271:
2272: CURSOR c_chk_for_govt_employer (p_user_entity_id NUMBER) IS
2273: SELECT 'RG'

Line 2536: ff_user_entities fue

2532: FROM ff_archive_items fai,
2533: pay_action_interlocks pai,
2534: pay_payroll_actions ppa,
2535: pay_assignment_actions paa,
2536: ff_user_entities fue
2537: where ppa.report_type = 'W2'
2538: and ppa.report_qualifier = 'FED'
2539: and ppa.report_category = 'MT'
2540: and effective_date = to_date('31/12/'||w2_year,'dd/mm/yyyy')

Line 2612: ,ff_user_entities fue

2608: ,ff_archive_items fai
2609: ,pay_assignment_actions paa
2610: ,pay_payroll_actions ppa
2611: ,pay_action_interlocks pai
2612: ,ff_user_entities fue
2613: WHERE
2614: ppa.report_type = 'W2'
2615: and ppa.report_qualifier = 'FED'
2616: and ppa.report_category = 'MT'

Line 2645: ,ff_user_entities fue

2641: ,ff_archive_items fai
2642: ,pay_assignment_actions paa
2643: ,pay_payroll_actions ppa
2644: ,pay_action_interlocks pai
2645: ,ff_user_entities fue
2646: WHERE
2647: ppa.report_type = 'W2'
2648: and ppa.report_qualifier = 'FED'
2649: and ppa.report_category = 'MT'

Line 2666: from ff_user_entities fai1, ff_archive_items fue1

2662: 'A_SIT_PRE_TAX_REDNS_PER_JD_GRE_YTD' ,
2663: 'A_W2_GROUP_TERM_LIFE_PER_GRE_YTD' )
2664: and paa.action_status = 'C'
2665: and exists (select 'Y'
2666: from ff_user_entities fai1, ff_archive_items fue1
2667: where fai1.user_entity_name = 'A_STATE_ABBREV'
2668: and fai1.user_entity_id = fue1.user_entity_id
2669: and fue1.value = 'PR'
2670: and fai1.user_entity_id = fue1.user_entity_id