APPS.PAY_US_PAYROLL_UTILS dependencies on PAY_US_STATES

Line 634: from pay_wc_funds wcf, pay_us_states uss

630: begin
631: select 'Y' into lv_value from dual
632: where exists (
633: select 'x'
634: from pay_wc_funds wcf, pay_us_states uss
635: where uss.state_code = lv_state_code
636: and uss.state_abbrev = wcf.state_code
637: and wcf.business_group_id =
638: nvl(hr_general.get_business_group_id, wcf.business_group_id));

Line 1141: l_state_name pay_us_states.state_name%TYPE;

1137: l_view_application_id fnd_lookup_values.view_application_id%TYPE;
1138: l_lookup_code fnd_lookup_values.lookup_code%TYPE;
1139: l_security_group_id fnd_lookup_values.security_group_id%TYPE;
1140: l_language fnd_lookup_values.language%TYPE;
1141: l_state_name pay_us_states.state_name%TYPE;
1142: l_application_id fnd_application.application_id%TYPE;
1143: l_security_group_id1 fnd_security_groups.security_group_id%TYPE;
1144: l_procedure_name VARCHAR2(50) := 'update_state_or_local_wh_link';
1145:

Line 1162: FROM pay_us_states

1158:
1159: /* Cursor to fetch the state name */
1160: CURSOR get_state_name_cur(v_state IN VARCHAR2) IS
1161: SELECT state_name
1162: FROM pay_us_states
1163: WHERE state_abbrev = v_state;
1164:
1165: /* Cursor to find the Security_Group_Id */
1166: CURSOR get_security_group_id_cur(v_application_id Number ) IS