APPS.HR_LEGISLATION_LOCAL dependencies on HR_S_US_GARN_FEE_RULES_F

Line 899: cursor gfr is select * from HR_S_US_GARN_FEE_RULES_F

895: cursor coti is select * from HR_S_US_COUNTY_TAX_INFO_F;
896: cursor sti is select * from HR_S_US_STATE_TAX_INFO_F;
897: cursor fti is select * from HR_S_US_FEDERAL_TAX_INFO_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

Line 921: hr_s_tab(6) := 'HR_S_US_GARN_FEE_RULES_F';

917: hr_s_tab(2) := 'HR_S_US_COUNTY_TAX_INFO_F';
918: hr_s_tab(3) := 'HR_S_US_STATE_TAX_INFO_F';
919: hr_s_tab(4) := 'HR_S_US_FEDERAL_TAX_INFO_F';
920: hr_s_tab(5) := 'HR_S_US_GARN_EXEMPTION_RULES_F';
921: hr_s_tab(6) := 'HR_S_US_GARN_FEE_RULES_F';
922: hr_s_tab(7) := 'HR_S_US_GARN_LIMIT_RULES_F';
923: hr_s_tab(8) := 'HR_S_REPORT_LOOKUPS';
924:
925: pay_tab(1) := 'PAY_US_CITY_TAX_INFO_F';

Line 944: HR_S_US_GARN_FEE_RULES_F);

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
946: begin
947: if ((l_patch_count > 0 ) and (pay_tab(lc_cnt) like 'PAY_US%INFO_F' )) then
948: null; /* do not transfer JIT data if not fresh install */