APPS.HR_LEGISLATION_LOCAL dependencies on PAY_US_GARN_FEE_RULES_F

Line 96: -- (pay_us_garn_fee_rules_f). Inserted the

92: -- legislation as it currently works for
93: -- US.
94: -- 115.24 VMEHTA 31-OCT-2000 Modified install_us_new to correctly
95: -- install garnishment_fee_rules
96: -- (pay_us_garn_fee_rules_f). Inserted the
97: -- logic to exit from the pgfr loop when
98: -- a record is found and also to set the
99: -- gfr_exist flag to 'N' at the beginning
100: -- of each iteration of the gfr loop.

Line 902: FROM PAY_US_GARN_FEE_RULES_F

898: cursor ger is select * from HR_S_US_GARN_EXEMPTION_RULES_F;
899: cursor gfr is select * from HR_S_US_GARN_FEE_RULES_F
900: order by fee_rule_id;
901: cursor pgfr is select creator_type, garn_category, state_code
902: FROM PAY_US_GARN_FEE_RULES_F
903: WHERE sysdate between effective_start_date
904: and effective_end_date;
905:
906: cursor glr is select * from HR_S_US_GARN_LIMIT_RULES_F;

Line 930: pay_tab(6) := 'PAY_US_GARN_FEE_RULES_F';

926: pay_tab(2) := 'PAY_US_COUNTY_TAX_INFO_F';
927: pay_tab(3) := 'PAY_US_STATE_TAX_INFO_F';
928: pay_tab(4) := 'PAY_US_FEDERAL_TAX_INFO_F';
929: pay_tab(5) := 'PAY_US_GARN_EXEMPTION_RULES_F';
930: pay_tab(6) := 'PAY_US_GARN_FEE_RULES_F';
931: pay_tab(7) := 'PAY_US_GARN_LIMIT_RULES_F';
932: pay_tab(8) := 'HR_REPORT_LOOKUPS';
933:
934: select count(*)

Line 940: if pay_tab(lc_cnt) = 'PAY_US_GARN_FEE_RULES_F' then

936: from pay_patch_status
937: where patch_name like 'JIT%';
938:
939: for lc_cnt in 5..8 loop
940: if pay_tab(lc_cnt) = 'PAY_US_GARN_FEE_RULES_F' then
941: DELETE FROM PAY_US_GARN_FEE_RULES_F
942: WHERE creator_type = 'SYSTEM'
943: AND 0 <> (SELECT COUNT(*) FROM
944: HR_S_US_GARN_FEE_RULES_F);

Line 941: DELETE FROM PAY_US_GARN_FEE_RULES_F

937: where patch_name like 'JIT%';
938:
939: for lc_cnt in 5..8 loop
940: if pay_tab(lc_cnt) = 'PAY_US_GARN_FEE_RULES_F' then
941: DELETE FROM PAY_US_GARN_FEE_RULES_F
942: WHERE creator_type = 'SYSTEM'
943: AND 0 <> (SELECT COUNT(*) FROM
944: HR_S_US_GARN_FEE_RULES_F);
945: else

Line 1087: insert into PAY_US_GARN_FEE_RULES_F

1083: l_prev_seq := gfr_rec.fee_rule_id;
1084:
1085: if gfr_exist = 'N' then
1086: savepoint new_primary_key;
1087: insert into PAY_US_GARN_FEE_RULES_F
1088: (
1089: FEE_RULE_ID,
1090: EFFECTIVE_START_DATE,
1091: EFFECTIVE_END_DATE,

Line 1135: from pay_us_garn_fee_rules_f;

1131: end loop;
1132:
1133: select max(fee_rule_id)
1134: into l_max_val
1135: from pay_us_garn_fee_rules_f;
1136:
1137: l_next_val := 0;
1138:
1139: /* consume sequence till there is no conflict */