APPS.PAY_US_PAYROLL_UTILS dependencies on FND_SECURITY_GROUPS

Line 1143: l_security_group_id1 fnd_security_groups.security_group_id%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:
1146: /* Cursor to fetch the lookup details */
1147: CURSOR get_lookup_value_cur(v_lookup_code IN VARCHAR2,

Line 1168: FROM fnd_lookup_types lt, fnd_security_groups sg

1164:
1165: /* Cursor to find the Security_Group_Id */
1166: CURSOR get_security_group_id_cur(v_application_id Number ) IS
1167: SELECT sg.security_group_id
1168: FROM fnd_lookup_types lt, fnd_security_groups sg
1169: WHERE lt.lookup_type = 'PAY_US_LOCAL_PDF_LINK_W4'
1170: AND lt.view_application_id = v_application_id
1171: AND lt.security_group_id = sg.security_group_id
1172: AND sg.security_group_key ='STANDARD';