APPS.PAY_US_MWR_REPORTING_PKG dependencies on FF_USER_ENTITIES

Line 336: ,ff_user_entities ue

332: SELECT fai.value,
333: pus.state_code || '-000-0000',
334: pus.state_abbrev
335: FROM ff_archive_items fai
336: ,ff_user_entities ue
337: ,pay_us_states pus
338: ,hr_locations hl
339: where hl.location_id = fai.value
340: and fai.user_entity_id = ue.user_entity_id

Line 457: ff_user_entities ue,

453:
454: select fai.value,
455: ppa.report_qualifier
456: from ff_archive_items fai,
457: ff_user_entities ue,
458: pay_assignment_actions paa,
459: pay_payroll_actions ppa
460: where fai.context1 = cp_sqwl_assact
461: and paa.assignment_action_id = fai.context1

Line 535: FROM ff_user_entities fue

531: BEGIN
532:
533: SELECT fue.user_entity_id
534: INTO l_user_entity_id
535: FROM ff_user_entities fue
536: WHERE fue.user_entity_name = 'A_SUI_ER_PRE_TAX_REDNS_PER_JD_GRE_QTD'
537: AND fue.legislation_code = 'US';
538:
539: OPEN c_get_sui_reds( p_sqwl_assact

Line 755: FROM ff_user_entities ue

751: -- get the user_entity_id for the 'A_SIT_GROSS_PER_JD_GRE_MON_*' DBI
752: IF i < 4 THEN
753: SELECT ue.user_entity_id
754: INTO l_user_entity_id
755: FROM ff_user_entities ue
756: WHERE ue.user_entity_name = 'A_SIT_GROSS_PER_JD_GRE_MON_' || to_char(i)
757: AND ue.legislation_code = 'US';
758: ELSE
759: SELECT ue.user_entity_id

Line 761: FROM ff_user_entities ue

757: AND ue.legislation_code = 'US';
758: ELSE
759: SELECT ue.user_entity_id
760: INTO l_user_entity_id
761: FROM ff_user_entities ue
762: WHERE ue.user_entity_name = 'A_SUI_ER_SUBJ_WHABLE_PER_JD_GRE_QTD'
763: AND ue.legislation_code = 'US';
764: END IF;
765: -- As of Q 1 2002 we no longer archive the A_SIT_GROSS_PER_JD_GRE_MON*

Line 1024: FROM ff_user_entities ue

1020: -- get the user_entity_id for the 'A_SIT_GROSS_PER_JD_GRE_MON_*' DBI
1021: hr_utility.trace('l_ma_resides find user entity');
1022: SELECT ue.user_entity_id
1023: INTO l_user_entity_id
1024: FROM ff_user_entities ue
1025: WHERE ue.user_entity_name = 'A_SUI_ER_SUBJ_WHABLE_PER_JD_GRE_QTD'
1026: AND ue.legislation_code = 'US';
1027:
1028: OPEN c_get_sui_subject ( l_sqwl_assact