APPS.PAY_US_MMREF_REPORTING dependencies on FF_USER_ENTITIES

Line 158: ff_user_entities UE

154: -- Get the defined_balance_id for the specified balance DB item.
155: CURSOR csr_defined_balance IS
156: SELECT TO_NUMBER(UE.creator_id)
157: FROM ff_database_items DI,
158: ff_user_entities UE
159: WHERE DI.user_name = p_db_item_name
160: AND UE.user_entity_id = DI.user_entity_id
161: AND UE.creator_type = 'B'
162: AND UE.legislation_code = 'US'; /* Bug:2296797 */

Line 350: SELECT user_entity_id from ff_user_entities

346: -- Cursor to fetch people in a given GRE with earnings in the given state to
347:
348: CURSOR c_tax_ein
349: IS
350: SELECT user_entity_id from ff_user_entities
351: WHERE user_entity_name = 'A_TAX_UNIT_EMPLOYER_IDENTIFICATION_NUMBER';
352:
353:
354:

Line 2414: FROM ff_user_entities

2410: l_jurisdiction varchar2(80);
2411:
2412: CURSOR c_state_sit IS
2413: SELECT user_entity_id
2414: FROM ff_user_entities
2415: WHERE user_entity_name = 'A_STATE_TAX_RULES_ORG_SIT_COMPANY_STATE_ID';
2416:
2417: CURSOR c_get_state_id
2418: IS

Line 2674: FROM ff_user_entities

2670: --
2671: --
2672: CURSOR c_get_user_entity_id IS
2673: SELECT user_entity_id
2674: FROM ff_user_entities
2675: WHERE user_entity_name = 'A_LC_FEDERAL_TAX_RULES_ORG_GOVERNMENT_EMPLOYER';
2676:
2677:
2678: CURSOR c_chk_for_govt_employer (p_user_entity_id NUMBER) IS

Line 2761: FROM ff_user_entities

2757: l_ue_id NUMBER;
2758: --
2759: CURSOR c_get_user_entity_id IS
2760: SELECT user_entity_id
2761: FROM ff_user_entities
2762: WHERE user_entity_name = 'A_LC_FEDERAL_TAX_RULES_ORG_GOVERNMENT_EMPLOYER';
2763:
2764: CURSOR c_chk_for_govt_employer (p_user_entity_id NUMBER) IS
2765: SELECT 'RG'

Line 3036: ff_user_entities fue

3032: FROM ff_archive_items fai,
3033: pay_action_interlocks pai,
3034: pay_payroll_actions ppa,
3035: pay_assignment_actions paa,
3036: ff_user_entities fue
3037: where ppa.report_type = 'W2'
3038: and ppa.report_qualifier = 'FED'
3039: and ppa.report_category = 'MT'
3040: and effective_date = to_date('31/12/'||w2_year,'dd/mm/yyyy')

Line 3118: ,ff_user_entities fue

3114: ,ff_archive_items fai
3115: ,pay_assignment_actions paa
3116: ,pay_payroll_actions ppa
3117: ,pay_action_interlocks pai
3118: ,ff_user_entities fue
3119: WHERE
3120: ppa.report_type = 'W2'
3121: and ppa.report_qualifier = 'FED'
3122: and ppa.report_category = 'MT'

Line 3151: ,ff_user_entities fue

3147: ,ff_archive_items fai
3148: ,pay_assignment_actions paa
3149: ,pay_payroll_actions ppa
3150: ,pay_action_interlocks pai
3151: ,ff_user_entities fue
3152: WHERE
3153: ppa.report_type = 'W2'
3154: and ppa.report_qualifier = 'FED'
3155: and ppa.report_category = 'MT'

Line 3172: from ff_user_entities fai1, ff_archive_items fue1

3168: 'A_SIT_PRE_TAX_REDNS_PER_JD_GRE_YTD' ,
3169: 'A_W2_GROUP_TERM_LIFE_PER_GRE_YTD' )
3170: and paa.action_status = 'C'
3171: and exists (select 'Y'
3172: from ff_user_entities fai1, ff_archive_items fue1
3173: where fai1.user_entity_name = 'A_STATE_ABBREV'
3174: and fai1.user_entity_id = fue1.user_entity_id
3175: and fue1.value = 'PR'
3176: and fai1.user_entity_id = fue1.user_entity_id