APPS.HR_H2PI_VALIDATE dependencies on HR_H2PI_CITY_TAX_RULES

Line 1034: l_jurisdiction_code hr_h2pi_city_tax_rules.jurisdiction_code%TYPE;

1030:
1031: l_ud_geocode hr_h2pi_patch_status.patch_name%TYPE;
1032: l_ed_geocode hr_h2pi_patch_status.patch_name%TYPE;
1033:
1034: l_jurisdiction_code hr_h2pi_city_tax_rules.jurisdiction_code%TYPE;
1035: l_jurisdiction_code_comp hr_h2pi_city_tax_rules.jurisdiction_code%TYPE;
1036:
1037: l_state_code hr_h2pi_us_modified_geocodes.state_code%TYPE;
1038: l_county_code hr_h2pi_us_modified_geocodes.county_code%TYPE;

Line 1035: l_jurisdiction_code_comp hr_h2pi_city_tax_rules.jurisdiction_code%TYPE;

1031: l_ud_geocode hr_h2pi_patch_status.patch_name%TYPE;
1032: l_ed_geocode hr_h2pi_patch_status.patch_name%TYPE;
1033:
1034: l_jurisdiction_code hr_h2pi_city_tax_rules.jurisdiction_code%TYPE;
1035: l_jurisdiction_code_comp hr_h2pi_city_tax_rules.jurisdiction_code%TYPE;
1036:
1037: l_state_code hr_h2pi_us_modified_geocodes.state_code%TYPE;
1038: l_county_code hr_h2pi_us_modified_geocodes.county_code%TYPE;
1039: l_city_code hr_h2pi_us_modified_geocodes.old_city_code%TYPE;

Line 1057: FROM hr_h2pi_city_tax_rules

1053: AND iv.element_type_id = et.element_type_id;
1054:
1055: CURSOR csr_ud_city_tax IS
1056: SELECT jurisdiction_code jurisdiction_code
1057: FROM hr_h2pi_city_tax_rules
1058: WHERE client_id = p_from_client_id
1059: UNION ALL
1060: SELECT screen_entry_value jurisdiction_code
1061: FROM hr_h2pi_element_entry_values

Line 1077: FROM hr_h2pi_city_tax_rules_v

1073: AND new_city_code = p_city_code;
1074:
1075: CURSOR csr_ed_city_tax IS
1076: SELECT jurisdiction_code jurisdiction_code
1077: FROM hr_h2pi_city_tax_rules_v
1078: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id
1079: UNION ALL
1080: SELECT screen_entry_value jurisdiction_code
1081: FROM hr_h2pi_element_entry_values_v eev,