APPS.PAY_US_SQWL_GRE dependencies on PAY_US_STATES

Line 92: lv_state_code pay_us_states.state_code%TYPE;

88: l_dev_status varchar2(10);
89: l_message varchar2(240);
90: l_return_val boolean;
91: lv_format_meaning fnd_lookup_values.meaning%TYPE;
92: lv_state_code pay_us_states.state_code%TYPE;
93: l_previous_sqwl_run_check number;
94: l_chk_gre_assign_actions number;
95:
96: CURSOR c_get_all_gres is

Line 238: FROM pay_us_states

234:
235: /* getting State Code */
236: IF p_state is NOT NULL THEN
237: SELECT state_code INTO lv_state_code
238: FROM pay_us_states
239: WHERE STATE_ABBREV = p_state;
240: END IF;
241:
242: IF p_report_option <> 'SQWL_OLD' THEN --change with lookup code

Line 634: lv_state_code pay_us_states.state_code%TYPE;

630: l_dev_status varchar2(10);
631: l_message varchar2(240);
632: l_return_val boolean;
633: lv_format_meaning fnd_lookup_values.meaning%TYPE;
634: lv_state_code pay_us_states.state_code%TYPE;
635: l_previous_smwl_run_check number;
636: l_chk_gre_assign_actions number;
637:
638: CURSOR c_get_all_gres is

Line 781: FROM pay_us_states

777:
778: /* getting State Code */
779: IF p_state is NOT NULL THEN
780: SELECT state_code INTO lv_state_code
781: FROM pay_us_states
782: WHERE STATE_ABBREV = p_state;
783: END IF;
784:
785: IF p_report_option <> 'SQWL_OLD' THEN --change with lookup code