APPS.PQP_US_FF_FUNCTIONS dependencies on PQP_ALIEN_STATE_TREATIES_F

Line 59: l_honor pqp_alien_state_treaties_f.treaty_honored_flag%TYPE := 'N';

55: ,p_ele_iv_jur_code IN VARCHAR2
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

Line 65: FROM pqp_alien_state_treaties_f pas

61: l_effective_date date;
62: --+
63: CURSOR c_state_honor (l_state_code varchar2) IS
64: SELECT pas.treaty_honored_flag
65: FROM pqp_alien_state_treaties_f pas
66: WHERE l_effective_date BETWEEN
67: pas.effective_start_date AND pas.effective_end_date
68: AND pas.state_code = l_state_code;
69: --+