DBA Data[Home] [Help]

APPS.HR_US_FF_UDF1 dependencies on FF_USER_ENTITIES

Line 530: FROM ff_user_entities

526: --pay_balance_pkg.set_context('PAYROLL_ID',l_payroll_id);
527:
528: SELECT creator_id
529: INTO l_defined_balance_tab(1).defined_balance_id
530: FROM ff_user_entities
531: WHERE user_entity_name = 'REGULAR_EARNINGS_' || l_asg_type || '_GRE_PTD'
532: AND legislation_code = 'US';
533:
534: l_defined_balance_tab(1).balance_value := 0;

Line 548: FROM ff_user_entities

544: l_context_tab(1).source_text2 := null;
545:
546: SELECT creator_id
547: INTO l_defined_balance_tab(2).defined_balance_id
548: FROM ff_user_entities
549: WHERE user_entity_name = 'SUPPLEMENTAL_EARNINGS_FOR_FIT_SUBJECT_TO_TAX_' || l_asg_type || '_GRE_PTD'
550: AND legislation_code = 'US';
551: l_defined_balance_tab(2).balance_value := 0;
552:

Line 565: FROM ff_user_entities

561: l_context_tab(2).source_text2 := null;
562:
563: SELECT creator_id
564: INTO l_defined_balance_tab(3).defined_balance_id
565: FROM ff_user_entities
566: WHERE user_entity_name = 'FIT_NON_AGGREGATE_RED_SUBJ_WHABLE_' || l_asg_type || '_GRE_PTD'
567: AND legislation_code = 'US';
568:
569: l_defined_balance_tab(3).balance_value := 0;

Line 584: FROM ff_user_entities

580: l_context_tab(3).source_text2 := null;
581:
582: SELECT creator_id
583: INTO l_defined_balance_tab(4).defined_balance_id
584: FROM ff_user_entities
585: WHERE user_entity_name = 'DEF_COMP_401K_' || l_asg_type || '_GRE_PTD'
586: AND legislation_code = 'US';
587:
588: l_defined_balance_tab(4).balance_value := 0;

Line 602: FROM ff_user_entities

598: l_context_tab(4).source_text2 := null;
599:
600: SELECT creator_id
601: INTO l_defined_balance_tab(5).defined_balance_id
602: FROM ff_user_entities
603: WHERE user_entity_name = 'DEF_COMP_403B_' || l_asg_type || '_GRE_PTD'
604: AND legislation_code = 'US';
605:
606: l_defined_balance_tab(5).balance_value := 0;

Line 620: FROM ff_user_entities

616: l_context_tab(5).source_text2 := null;
617:
618: SELECT creator_id
619: INTO l_defined_balance_tab(6).defined_balance_id
620: FROM ff_user_entities
621: WHERE user_entity_name = 'DEF_COMP_457_' || l_asg_type || '_GRE_PTD'
622: AND legislation_code = 'US';
623:
624: l_defined_balance_tab(6).balance_value := 0;

Line 638: FROM ff_user_entities

634: l_context_tab(6).source_text2 := null;
635:
636: SELECT creator_id
637: INTO l_defined_balance_tab(7).defined_balance_id
638: FROM ff_user_entities
639: WHERE user_entity_name = 'OTHER_PRETAX_' || l_asg_type || '_GRE_PTD'
640: AND legislation_code = 'US';
641:
642: hr_utility.trace('OTHER_PRETAX_' || l_asg_type || '_GRE_PTD' || ' = '

Line 656: FROM ff_user_entities

652: l_context_tab(7).source_text2 := null;
653:
654: SELECT creator_id
655: INTO l_defined_balance_tab(8).defined_balance_id
656: FROM ff_user_entities
657: WHERE user_entity_name = 'SECTION_125_' || l_asg_type || '_GRE_PTD'
658: AND legislation_code = 'US';
659:
660: hr_utility.trace('SECTION_125_' || l_asg_type || '_GRE_PTD' || ' = '

Line 674: FROM ff_user_entities

670: l_context_tab(8).source_text2 := null;
671:
672: SELECT creator_id
673: INTO l_defined_balance_tab(9).defined_balance_id
674: FROM ff_user_entities
675: WHERE user_entity_name = 'DEPENDENT_CARE_' || l_asg_type || '_GRE_PTD'
676: AND legislation_code = 'US';
677:
678: hr_utility.trace('DEPENDENT_CARE_' || l_asg_type || '_GRE_PTD' || ' = '

Line 692: FROM ff_user_entities

688: l_context_tab(9).source_text2 := null;
689:
690: SELECT creator_id
691: INTO l_defined_balance_tab(10).defined_balance_id
692: FROM ff_user_entities
693: WHERE user_entity_name = 'DEF_COMP_401K_FOR_FIT_SUBJECT_TO_TAX_' || l_asg_type || '_GRE_PTD'
694: AND legislation_code = 'US';
695:
696: hr_utility.trace('DEF_COMP_401K_FOR_FIT_SUBJECT_TO_TAX_' || l_asg_type || '_GRE_PTD' || ' = '

Line 711: FROM ff_user_entities

707: l_context_tab(10).source_text2 := null;
708:
709: SELECT creator_id
710: INTO l_defined_balance_tab(11).defined_balance_id
711: FROM ff_user_entities
712: WHERE user_entity_name = 'DEF_COMP_403B_FOR_FIT_SUBJECT_TO_TAX_' || l_asg_type || '_GRE_PTD'
713: AND legislation_code = 'US';
714:
715: hr_utility.trace('DEF_COMP_403B_FOR_FIT_SUBJECT_TO_TAX_' || l_asg_type || '_GRE_PTD' || ' = '

Line 729: FROM ff_user_entities

725: l_context_tab(11).source_text2 := null;
726:
727: SELECT creator_id
728: INTO l_defined_balance_tab(12).defined_balance_id
729: FROM ff_user_entities
730: WHERE user_entity_name = 'DEF_COMP_457_FOR_FIT_SUBJECT_TO_TAX_' || l_asg_type || '_GRE_PTD'
731: AND legislation_code = 'US';
732:
733: hr_utility.trace('DEF_COMP_457_FOR_FIT_SUBJECT_TO_TAX_' || l_asg_type || '_GRE_PTD' || ' = '

Line 747: FROM ff_user_entities

743: l_context_tab(12).source_text2 := null;
744:
745: SELECT creator_id
746: INTO l_defined_balance_tab(13).defined_balance_id
747: FROM ff_user_entities
748: WHERE user_entity_name = 'OTHER_PRETAX_FOR_FIT_SUBJECT_TO_TAX_' || l_asg_type || '_GRE_PTD'
749: AND legislation_code = 'US';
750:
751: hr_utility.trace('OTHER_PRETAX_FOR_FIT_SUBJECT_TO_TAX_' || l_asg_type || '_GRE_PTD' || ' = '

Line 765: FROM ff_user_entities

761: l_context_tab(13).source_text2 := null;
762:
763: SELECT creator_id
764: INTO l_defined_balance_tab(14).defined_balance_id
765: FROM ff_user_entities
766: WHERE user_entity_name = 'SECTION_125_FOR_FIT_SUBJECT_TO_TAX_' || l_asg_type || '_GRE_PTD'
767: AND legislation_code = 'US';
768:
769: hr_utility.trace('SECTION_125_FOR_FIT_SUBJECT_TO_TAX_' || l_asg_type || '_GRE_PTD' || ' = '

Line 783: FROM ff_user_entities

779: l_context_tab(14).source_text2 := null;
780:
781: SELECT creator_id
782: INTO l_defined_balance_tab(15).defined_balance_id
783: FROM ff_user_entities
784: WHERE user_entity_name = 'DEPENDENT_CARE_FOR_FIT_SUBJECT_TO_TAX_' || l_asg_type || '_GRE_PTD'
785: AND legislation_code = 'US';
786:
787: hr_utility.trace('DEPENDENT_CARE_FOR_FIT_SUBJECT_TO_TAX_' || l_asg_type || '_GRE_PTD' || ' = '

Line 801: FROM ff_user_entities

797: l_context_tab(15).source_text2 := null;
798:
799: SELECT creator_id
800: INTO l_defined_balance_tab(16).defined_balance_id
801: FROM ff_user_entities
802: WHERE user_entity_name = 'FIT_NON_W2_DEF_COMP_401_' || l_asg_type || '_GRE_PTD'
803: AND legislation_code = 'US';
804:
805: hr_utility.trace('FIT_NON_W2_DEF_COMP_401_' || l_asg_type || '_GRE_PTD' || ' = '

Line 819: FROM ff_user_entities

815: l_context_tab(16).source_text2 := null;
816:
817: SELECT creator_id
818: INTO l_defined_balance_tab(17).defined_balance_id
819: FROM ff_user_entities
820: WHERE user_entity_name = 'FIT_NON_W2_DEF_COMP_403_' || l_asg_type || '_GRE_PTD'
821: AND legislation_code = 'US';
822:
823: hr_utility.trace('FIT_NON_W2_DEF_COMP_403_' || l_asg_type || '_GRE_PTD' || ' = '

Line 837: FROM ff_user_entities

833: l_context_tab(17).source_text2 := null;
834:
835: SELECT creator_id
836: INTO l_defined_balance_tab(18).defined_balance_id
837: FROM ff_user_entities
838: WHERE user_entity_name = 'FIT_NON_W2_DEF_COMP_457_' || l_asg_type || '_GRE_PTD'
839: AND legislation_code = 'US';
840:
841: hr_utility.trace('FIT_NON_W2_DEF_COMP_457_' || l_asg_type || '_GRE_PTD' || ' = '

Line 855: FROM ff_user_entities

851: l_context_tab(18).source_text2 := null;
852:
853: SELECT creator_id
854: INTO l_defined_balance_tab(19).defined_balance_id
855: FROM ff_user_entities
856: WHERE user_entity_name = 'FIT_NON_W2_SECTION_125_' || l_asg_type || '_GRE_PTD'
857: AND legislation_code = 'US';
858:
859: hr_utility.trace('FIT_NON_W2_SECTION_125_' || l_asg_type || '_GRE_PTD' || ' = '

Line 873: FROM ff_user_entities

869: l_context_tab(19).source_text2 := null;
870:
871: SELECT creator_id
872: INTO l_defined_balance_tab(20).defined_balance_id
873: FROM ff_user_entities
874: WHERE user_entity_name = 'FIT_NON_W2_DEPENDENT_CARE_' || l_asg_type || '_GRE_PTD'
875: AND legislation_code = 'US';
876:
877: hr_utility.trace('FIT_NON_W2_DEPENDENT_CARE_' || l_asg_type || '_GRE_PTD' || ' = '

Line 891: FROM ff_user_entities

887: l_context_tab(20).source_text2 := null;
888:
889: SELECT creator_id
890: INTO l_defined_balance_tab(21).defined_balance_id
891: FROM ff_user_entities
892: WHERE user_entity_name = 'FIT_NON_W2_OTHER_PRETAX_' || l_asg_type || '_GRE_PTD'
893: AND legislation_code = 'US';
894:
895: hr_utility.trace('FIT_NON_W2_OTHER_PRETAX_' || l_asg_type || '_GRE_PTD' || ' = '

Line 910: FROM ff_user_entities

906:
907:
908: SELECT creator_id
909: INTO l_defined_balance_tab(22).defined_balance_id
910: FROM ff_user_entities
911: WHERE user_entity_name = 'FIT_WITHHELD_' || l_asg_type || '_GRE_PTD'
912: AND legislation_code = 'US';
913:
914: hr_utility.trace('FIT_WITHHELD_' || l_asg_type || '_GRE_PTD' || ' = '

Line 928: FROM ff_user_entities

924: l_context_tab(22).source_text2 := null;
925:
926: SELECT creator_id
927: INTO l_defined_balance_tab(23).defined_balance_id
928: FROM ff_user_entities
929: WHERE user_entity_name = 'FIT_SUPP_WITHHELD_' || l_asg_type || '_GRE_PTD'
930: AND legislation_code = 'US';
931:
932: hr_utility.trace('FIT_SUPP_WITHHELD_' || l_asg_type || '_GRE_PTD' || ' = '

Line 1038: FROM ff_user_entities

1034: END IF;
1035:
1036: SELECT creator_id
1037: INTO l_defined_balance_tab(1).defined_balance_id
1038: FROM ff_user_entities
1039: WHERE user_entity_name = 'SIT_SUBJ_WHABLE_' || l_asg_type || '_JD_GRE_PTD'
1040: AND legislation_code = 'US';
1041:
1042: hr_utility.trace('SIT_SUBJ_WHABLE_' || l_asg_type || '_JD_GRE_PTD' || ' = '

Line 1056: FROM ff_user_entities

1052: l_context_tab(1).source_text2 := null;
1053:
1054: SELECT creator_id
1055: INTO l_defined_balance_tab(2).defined_balance_id
1056: FROM ff_user_entities
1057: WHERE user_entity_name = 'SIT_NON_AGGREGATE_RED_SUBJ_WHABLE_' || l_asg_type || '_JD_GRE_PTD'
1058: AND legislation_code = 'US';
1059:
1060: hr_utility.trace('SIT_NON_AGGREGATE_RED_SUBJ_WHABLE_' || l_asg_type || '_JD_GRE_PTD' || ' = '

Line 1074: FROM ff_user_entities

1070: l_context_tab(2).source_text2 := null;
1071:
1072: SELECT creator_id
1073: INTO l_defined_balance_tab(3).defined_balance_id
1074: FROM ff_user_entities
1075: WHERE user_entity_name = 'SIT_PRE_TAX_REDNS_' || l_asg_type || '_JD_GRE_PTD'
1076: AND legislation_code = 'US';
1077:
1078: hr_utility.trace('SIT_PRE_TAX_REDNS_' || l_asg_type || '_JD_GRE_PTD' || ' = '

Line 1092: FROM ff_user_entities

1088: l_context_tab(3).source_text2 := null;
1089:
1090: SELECT creator_id
1091: INTO l_defined_balance_tab(4).defined_balance_id
1092: FROM ff_user_entities
1093: WHERE user_entity_name = 'SIT_WITHHELD_' || l_asg_type || '_JD_GRE_PTD'
1094: AND legislation_code = 'US';
1095:
1096: hr_utility.trace('SIT_WITHHELD_' || l_asg_type || '_JD_GRE_PTD' || ' = '

Line 1110: FROM ff_user_entities

1106: l_context_tab(4).source_text2 := null;
1107:
1108: SELECT creator_id
1109: INTO l_defined_balance_tab(5).defined_balance_id
1110: FROM ff_user_entities
1111: WHERE user_entity_name = 'SIT_SUPP_WITHHELD_' || l_asg_type || '_JD_GRE_PTD'
1112: AND legislation_code = 'US';
1113:
1114: hr_utility.trace('SIT_SUPP_WITHHELD_' || l_asg_type || '_JD_GRE_PTD' || ' = '

Line 1170: FROM ff_user_entities

1166: ELSIF p_fed_or_state = 'CITY' THEN
1167: hr_utility.trace('p_fed_or_state = CITY');
1168: SELECT creator_id
1169: INTO l_defined_balance_tab(1).defined_balance_id
1170: FROM ff_user_entities
1171: WHERE user_entity_name = 'CITY_WITHHELD_' || l_asg_type || '_JD_GRE_PTD'
1172: AND legislation_code = 'US';
1173:
1174: hr_utility.trace('CITY_WITHHELD_' || l_asg_type || '_JD_GRE_PTD' || ' = '

Line 1207: FROM ff_user_entities

1203: ELSIF p_fed_or_state = 'COUNTY' THEN
1204: hr_utility.trace('p_fed_or_state = COUNTY');
1205: SELECT creator_id
1206: INTO l_defined_balance_tab(1).defined_balance_id
1207: FROM ff_user_entities
1208: WHERE user_entity_name = 'COUNTY_WITHHELD_' || l_asg_type || '_JD_GRE_PTD'
1209: AND legislation_code = 'US';
1210:
1211: hr_utility.trace('COUNTY_WITHHELD_' || l_asg_type || '_JD_GRE_PTD' || ' = '

Line 1244: FROM ff_user_entities

1240: ELSIF p_fed_or_state = 'SCHOOL' THEN
1241: hr_utility.trace('p_fed_or_state = SCHOOL');
1242: SELECT creator_id
1243: INTO l_defined_balance_tab(1).defined_balance_id
1244: FROM ff_user_entities
1245: WHERE user_entity_name = 'SCHOOL_WITHHELD_' || l_asg_type || '_JD_GRE_PTD'
1246: AND legislation_code = 'US';
1247:
1248: hr_utility.trace('SCHOOL_WITHHELD_' || l_asg_type || '_JD_GRE_PTD' || ' = '