APPS.PQP_US_FF_FUNCTIONS dependencies on PAY_STATE_RULES

Line 60: l_state_code pay_state_rules.state_code%TYPE;

56: ,p_override_loc_state IN VARCHAR2 )
57: RETURN varchar2 IS
58: --+
59: l_honor pqp_alien_state_treaties_f.treaty_honored_flag%TYPE := 'N';
60: l_state_code pay_state_rules.state_code%TYPE;
61: l_effective_date date;
62: --+
63: CURSOR c_state_honor (l_state_code varchar2) IS
64: SELECT pas.treaty_honored_flag

Line 72: FROM pay_state_rules

68: AND pas.state_code = l_state_code;
69: --+
70: CURSOR c_jurisdiction IS
71: SELECT state_code
72: FROM pay_state_rules
73: WHERE substr(jurisdiction_code,1,2) = substr(p_ele_iv_jur_code,1,2);
74: --+
75: BEGIN
76: l_effective_date := TRUNC(pqp_car_mileage_functions.pqp_get_date_paid

Line 185: FROM pay_state_rules

181: AND ASG.assignment_id = p_assignment_id;
182: --+
183: CURSOR c_jurisdiction IS
184: SELECT jurisdiction_code
185: FROM pay_state_rules
186: WHERE state_code = p_state_code;
187: --+
188: BEGIN
189: IF p_payroll_action_id IS NOT NULL THEN