DBA Data[Home] [Help]

APPS.PAY_US_SQWL_GRE dependencies on FND_LOOKUP_VALUES

Line 91: lv_format_meaning fnd_lookup_values.meaning%TYPE;

87: l_dev_phase varchar2(10);
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:

Line 130: FROM fnd_lookup_values flv

126: );
127:
128: CURSOR c_get_format_type(cp_state_abbrv IN VARCHAR2,cp_format IN VARCHAR2) IS
129: SELECT flv.meaning
130: FROM fnd_lookup_values flv
131: WHERE flv.lookup_type = cp_state_abbrv||'_SQWL_MEDIA_TYPE'
132: AND flv.lookup_code = cp_format
133: AND flv.enabled_flag = 'Y'
134: AND LANGUAGE='US';

Line 633: lv_format_meaning fnd_lookup_values.meaning%TYPE;

629: l_dev_phase varchar2(10);
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:

Line 672: FROM fnd_lookup_values flv

668: );
669:
670: CURSOR c_get_format_type(cp_state_abbrv IN VARCHAR2,cp_format IN VARCHAR2) IS
671: SELECT flv.meaning
672: FROM fnd_lookup_values flv
673: WHERE flv.lookup_type = cp_state_abbrv||'_SMWL_MEDIA_TYPE'
674: AND flv.lookup_code = cp_format
675: AND flv.enabled_flag = 'Y'
676: AND LANGUAGE='US';