eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.HR_US_FF_UDF1 dependencies on FF_USER_ENTITIES

Line 489: FROM ff_user_entities

485: --pay_balance_pkg.set_context('PAYROLL_ID',l_payroll_id);
486:
487: SELECT creator_id
488: INTO l_defined_balance_tab(1).defined_balance_id
489: FROM ff_user_entities
490: WHERE user_entity_name = 'REGULAR_EARNINGS_' || l_asg_type || '_GRE_PTD'
491: AND legislation_code = 'US';
492:
493: l_defined_balance_tab(1).balance_value := 0;

Line 507: FROM ff_user_entities

503: l_context_tab(1).source_text2 := null;
504:
505: SELECT creator_id
506: INTO l_defined_balance_tab(2).defined_balance_id
507: FROM ff_user_entities
508: WHERE user_entity_name = 'SUPPLEMENTAL_EARNINGS_FOR_FIT_SUBJECT_TO_TAX_' || l_asg_type || '_GRE_PTD'
509: AND legislation_code = 'US';
510: l_defined_balance_tab(2).balance_value := 0;
511:

Line 524: FROM ff_user_entities

520: l_context_tab(2).source_text2 := null;
521:
522: SELECT creator_id
523: INTO l_defined_balance_tab(3).defined_balance_id
524: FROM ff_user_entities
525: WHERE user_entity_name = 'FIT_NON_AGGREGATE_RED_SUBJ_WHABLE_' || l_asg_type || '_GRE_PTD'
526: AND legislation_code = 'US';
527:
528: l_defined_balance_tab(3).balance_value := 0;

Line 543: FROM ff_user_entities

539: l_context_tab(3).source_text2 := null;
540:
541: SELECT creator_id
542: INTO l_defined_balance_tab(4).defined_balance_id
543: FROM ff_user_entities
544: WHERE user_entity_name = 'DEF_COMP_401K_' || l_asg_type || '_GRE_PTD'
545: AND legislation_code = 'US';
546:
547: l_defined_balance_tab(4).balance_value := 0;

Line 561: FROM ff_user_entities

557: l_context_tab(4).source_text2 := null;
558:
559: SELECT creator_id
560: INTO l_defined_balance_tab(5).defined_balance_id
561: FROM ff_user_entities
562: WHERE user_entity_name = 'DEF_COMP_403B_' || l_asg_type || '_GRE_PTD'
563: AND legislation_code = 'US';
564:
565: l_defined_balance_tab(5).balance_value := 0;

Line 579: FROM ff_user_entities

575: l_context_tab(5).source_text2 := null;
576:
577: SELECT creator_id
578: INTO l_defined_balance_tab(6).defined_balance_id
579: FROM ff_user_entities
580: WHERE user_entity_name = 'DEF_COMP_457_' || l_asg_type || '_GRE_PTD'
581: AND legislation_code = 'US';
582:
583: l_defined_balance_tab(6).balance_value := 0;

Line 597: FROM ff_user_entities

593: l_context_tab(6).source_text2 := null;
594:
595: SELECT creator_id
596: INTO l_defined_balance_tab(7).defined_balance_id
597: FROM ff_user_entities
598: WHERE user_entity_name = 'OTHER_PRETAX_' || l_asg_type || '_GRE_PTD'
599: AND legislation_code = 'US';
600:
601: hr_utility.trace('OTHER_PRETAX_' || l_asg_type || '_GRE_PTD' || ' = '

Line 615: FROM ff_user_entities

611: l_context_tab(7).source_text2 := null;
612:
613: SELECT creator_id
614: INTO l_defined_balance_tab(8).defined_balance_id
615: FROM ff_user_entities
616: WHERE user_entity_name = 'SECTION_125_' || l_asg_type || '_GRE_PTD'
617: AND legislation_code = 'US';
618:
619: hr_utility.trace('SECTION_125_' || l_asg_type || '_GRE_PTD' || ' = '

Line 633: FROM ff_user_entities

629: l_context_tab(8).source_text2 := null;
630:
631: SELECT creator_id
632: INTO l_defined_balance_tab(9).defined_balance_id
633: FROM ff_user_entities
634: WHERE user_entity_name = 'DEPENDENT_CARE_' || l_asg_type || '_GRE_PTD'
635: AND legislation_code = 'US';
636:
637: hr_utility.trace('DEPENDENT_CARE_' || l_asg_type || '_GRE_PTD' || ' = '

Line 651: FROM ff_user_entities

647: l_context_tab(9).source_text2 := null;
648:
649: SELECT creator_id
650: INTO l_defined_balance_tab(10).defined_balance_id
651: FROM ff_user_entities
652: WHERE user_entity_name = 'DEF_COMP_401K_FOR_FIT_SUBJECT_TO_TAX_' || l_asg_type || '_GRE_PTD'
653: AND legislation_code = 'US';
654:
655: hr_utility.trace('DEF_COMP_401K_FOR_FIT_SUBJECT_TO_TAX_' || l_asg_type || '_GRE_PTD' || ' = '

Line 670: FROM ff_user_entities

666: l_context_tab(10).source_text2 := null;
667:
668: SELECT creator_id
669: INTO l_defined_balance_tab(11).defined_balance_id
670: FROM ff_user_entities
671: WHERE user_entity_name = 'DEF_COMP_403B_FOR_FIT_SUBJECT_TO_TAX_' || l_asg_type || '_GRE_PTD'
672: AND legislation_code = 'US';
673:
674: hr_utility.trace('DEF_COMP_403B_FOR_FIT_SUBJECT_TO_TAX_' || l_asg_type || '_GRE_PTD' || ' = '

Line 688: FROM ff_user_entities

684: l_context_tab(11).source_text2 := null;
685:
686: SELECT creator_id
687: INTO l_defined_balance_tab(12).defined_balance_id
688: FROM ff_user_entities
689: WHERE user_entity_name = 'DEF_COMP_457_FOR_FIT_SUBJECT_TO_TAX_' || l_asg_type || '_GRE_PTD'
690: AND legislation_code = 'US';
691:
692: hr_utility.trace('DEF_COMP_457_FOR_FIT_SUBJECT_TO_TAX_' || l_asg_type || '_GRE_PTD' || ' = '

Line 706: FROM ff_user_entities

702: l_context_tab(12).source_text2 := null;
703:
704: SELECT creator_id
705: INTO l_defined_balance_tab(13).defined_balance_id
706: FROM ff_user_entities
707: WHERE user_entity_name = 'OTHER_PRETAX_FOR_FIT_SUBJECT_TO_TAX_' || l_asg_type || '_GRE_PTD'
708: AND legislation_code = 'US';
709:
710: hr_utility.trace('OTHER_PRETAX_FOR_FIT_SUBJECT_TO_TAX_' || l_asg_type || '_GRE_PTD' || ' = '

Line 724: FROM ff_user_entities

720: l_context_tab(13).source_text2 := null;
721:
722: SELECT creator_id
723: INTO l_defined_balance_tab(14).defined_balance_id
724: FROM ff_user_entities
725: WHERE user_entity_name = 'SECTION_125_FOR_FIT_SUBJECT_TO_TAX_' || l_asg_type || '_GRE_PTD'
726: AND legislation_code = 'US';
727:
728: hr_utility.trace('SECTION_125_FOR_FIT_SUBJECT_TO_TAX_' || l_asg_type || '_GRE_PTD' || ' = '

Line 742: FROM ff_user_entities

738: l_context_tab(14).source_text2 := null;
739:
740: SELECT creator_id
741: INTO l_defined_balance_tab(15).defined_balance_id
742: FROM ff_user_entities
743: WHERE user_entity_name = 'DEPENDENT_CARE_FOR_FIT_SUBJECT_TO_TAX_' || l_asg_type || '_GRE_PTD'
744: AND legislation_code = 'US';
745:
746: hr_utility.trace('DEPENDENT_CARE_FOR_FIT_SUBJECT_TO_TAX_' || l_asg_type || '_GRE_PTD' || ' = '

Line 760: FROM ff_user_entities

756: l_context_tab(15).source_text2 := null;
757:
758: SELECT creator_id
759: INTO l_defined_balance_tab(16).defined_balance_id
760: FROM ff_user_entities
761: WHERE user_entity_name = 'FIT_NON_W2_DEF_COMP_401_' || l_asg_type || '_GRE_PTD'
762: AND legislation_code = 'US';
763:
764: hr_utility.trace('FIT_NON_W2_DEF_COMP_401_' || l_asg_type || '_GRE_PTD' || ' = '

Line 778: FROM ff_user_entities

774: l_context_tab(16).source_text2 := null;
775:
776: SELECT creator_id
777: INTO l_defined_balance_tab(17).defined_balance_id
778: FROM ff_user_entities
779: WHERE user_entity_name = 'FIT_NON_W2_DEF_COMP_403_' || l_asg_type || '_GRE_PTD'
780: AND legislation_code = 'US';
781:
782: hr_utility.trace('FIT_NON_W2_DEF_COMP_403_' || l_asg_type || '_GRE_PTD' || ' = '

Line 796: FROM ff_user_entities

792: l_context_tab(17).source_text2 := null;
793:
794: SELECT creator_id
795: INTO l_defined_balance_tab(18).defined_balance_id
796: FROM ff_user_entities
797: WHERE user_entity_name = 'FIT_NON_W2_DEF_COMP_457_' || l_asg_type || '_GRE_PTD'
798: AND legislation_code = 'US';
799:
800: hr_utility.trace('FIT_NON_W2_DEF_COMP_457_' || l_asg_type || '_GRE_PTD' || ' = '

Line 814: FROM ff_user_entities

810: l_context_tab(18).source_text2 := null;
811:
812: SELECT creator_id
813: INTO l_defined_balance_tab(19).defined_balance_id
814: FROM ff_user_entities
815: WHERE user_entity_name = 'FIT_NON_W2_SECTION_125_' || l_asg_type || '_GRE_PTD'
816: AND legislation_code = 'US';
817:
818: hr_utility.trace('FIT_NON_W2_SECTION_125_' || l_asg_type || '_GRE_PTD' || ' = '

Line 832: FROM ff_user_entities

828: l_context_tab(19).source_text2 := null;
829:
830: SELECT creator_id
831: INTO l_defined_balance_tab(20).defined_balance_id
832: FROM ff_user_entities
833: WHERE user_entity_name = 'FIT_NON_W2_DEPENDENT_CARE_' || l_asg_type || '_GRE_PTD'
834: AND legislation_code = 'US';
835:
836: hr_utility.trace('FIT_NON_W2_DEPENDENT_CARE_' || l_asg_type || '_GRE_PTD' || ' = '

Line 850: FROM ff_user_entities

846: l_context_tab(20).source_text2 := null;
847:
848: SELECT creator_id
849: INTO l_defined_balance_tab(21).defined_balance_id
850: FROM ff_user_entities
851: WHERE user_entity_name = 'FIT_NON_W2_OTHER_PRETAX_' || l_asg_type || '_GRE_PTD'
852: AND legislation_code = 'US';
853:
854: hr_utility.trace('FIT_NON_W2_OTHER_PRETAX_' || l_asg_type || '_GRE_PTD' || ' = '

Line 869: FROM ff_user_entities

865:
866:
867: SELECT creator_id
868: INTO l_defined_balance_tab(22).defined_balance_id
869: FROM ff_user_entities
870: WHERE user_entity_name = 'FIT_WITHHELD_' || l_asg_type || '_GRE_PTD'
871: AND legislation_code = 'US';
872:
873: hr_utility.trace('FIT_WITHHELD_' || l_asg_type || '_GRE_PTD' || ' = '

Line 887: FROM ff_user_entities

883: l_context_tab(22).source_text2 := null;
884:
885: SELECT creator_id
886: INTO l_defined_balance_tab(23).defined_balance_id
887: FROM ff_user_entities
888: WHERE user_entity_name = 'FIT_SUPP_WITHHELD_' || l_asg_type || '_GRE_PTD'
889: AND legislation_code = 'US';
890:
891: hr_utility.trace('FIT_SUPP_WITHHELD_' || l_asg_type || '_GRE_PTD' || ' = '

Line 997: FROM ff_user_entities

993: END IF;
994:
995: SELECT creator_id
996: INTO l_defined_balance_tab(1).defined_balance_id
997: FROM ff_user_entities
998: WHERE user_entity_name = 'SIT_SUBJ_WHABLE_' || l_asg_type || '_JD_GRE_PTD'
999: AND legislation_code = 'US';
1000:
1001: hr_utility.trace('SIT_SUBJ_WHABLE_' || l_asg_type || '_JD_GRE_PTD' || ' = '

Line 1015: FROM ff_user_entities

1011: l_context_tab(1).source_text2 := null;
1012:
1013: SELECT creator_id
1014: INTO l_defined_balance_tab(2).defined_balance_id
1015: FROM ff_user_entities
1016: WHERE user_entity_name = 'SIT_NON_AGGREGATE_RED_SUBJ_WHABLE_' || l_asg_type || '_JD_GRE_PTD'
1017: AND legislation_code = 'US';
1018:
1019: hr_utility.trace('SIT_NON_AGGREGATE_RED_SUBJ_WHABLE_' || l_asg_type || '_JD_GRE_PTD' || ' = '

Line 1033: FROM ff_user_entities

1029: l_context_tab(2).source_text2 := null;
1030:
1031: SELECT creator_id
1032: INTO l_defined_balance_tab(3).defined_balance_id
1033: FROM ff_user_entities
1034: WHERE user_entity_name = 'SIT_PRE_TAX_REDNS_' || l_asg_type || '_JD_GRE_PTD'
1035: AND legislation_code = 'US';
1036:
1037: hr_utility.trace('SIT_PRE_TAX_REDNS_' || l_asg_type || '_JD_GRE_PTD' || ' = '

Line 1051: FROM ff_user_entities

1047: l_context_tab(3).source_text2 := null;
1048:
1049: SELECT creator_id
1050: INTO l_defined_balance_tab(4).defined_balance_id
1051: FROM ff_user_entities
1052: WHERE user_entity_name = 'SIT_WITHHELD_' || l_asg_type || '_JD_GRE_PTD'
1053: AND legislation_code = 'US';
1054:
1055: hr_utility.trace('SIT_WITHHELD_' || l_asg_type || '_JD_GRE_PTD' || ' = '

Line 1069: FROM ff_user_entities

1065: l_context_tab(4).source_text2 := null;
1066:
1067: SELECT creator_id
1068: INTO l_defined_balance_tab(5).defined_balance_id
1069: FROM ff_user_entities
1070: WHERE user_entity_name = 'SIT_SUPP_WITHHELD_' || l_asg_type || '_JD_GRE_PTD'
1071: AND legislation_code = 'US';
1072:
1073: hr_utility.trace('SIT_SUPP_WITHHELD_' || l_asg_type || '_JD_GRE_PTD' || ' = '

Line 1129: FROM ff_user_entities

1125: ELSIF p_fed_or_state = 'CITY' THEN
1126: hr_utility.trace('p_fed_or_state = CITY');
1127: SELECT creator_id
1128: INTO l_defined_balance_tab(1).defined_balance_id
1129: FROM ff_user_entities
1130: WHERE user_entity_name = 'CITY_WITHHELD_' || l_asg_type || '_JD_GRE_PTD'
1131: AND legislation_code = 'US';
1132:
1133: hr_utility.trace('CITY_WITHHELD_' || l_asg_type || '_JD_GRE_PTD' || ' = '

Line 1166: FROM ff_user_entities

1162: ELSIF p_fed_or_state = 'COUNTY' THEN
1163: hr_utility.trace('p_fed_or_state = COUNTY');
1164: SELECT creator_id
1165: INTO l_defined_balance_tab(1).defined_balance_id
1166: FROM ff_user_entities
1167: WHERE user_entity_name = 'COUNTY_WITHHELD_' || l_asg_type || '_JD_GRE_PTD'
1168: AND legislation_code = 'US';
1169:
1170: hr_utility.trace('COUNTY_WITHHELD_' || l_asg_type || '_JD_GRE_PTD' || ' = '

Line 1203: FROM ff_user_entities

1199: ELSIF p_fed_or_state = 'SCHOOL' THEN
1200: hr_utility.trace('p_fed_or_state = SCHOOL');
1201: SELECT creator_id
1202: INTO l_defined_balance_tab(1).defined_balance_id
1203: FROM ff_user_entities
1204: WHERE user_entity_name = 'SCHOOL_WITHHELD_' || l_asg_type || '_JD_GRE_PTD'
1205: AND legislation_code = 'US';
1206:
1207: hr_utility.trace('SCHOOL_WITHHELD_' || l_asg_type || '_JD_GRE_PTD' || ' = '