185: l_sysdate DATE := G_SYSDATE;
186:
187: CURSOR lkup_csr IS
188: SELECT '1'
189: FROM fnd_lookup_values flv,
190: fnd_lookup_types flt
191: WHERE
192: flv.lookup_type = p_lookup_type
193: AND flv.view_application_id = p_view_app_id
1058: l_sysdate DATE := G_SYSDATE;
1059:
1060: CURSOR lkup_csr IS
1061: SELECT meaning
1062: FROM fnd_lookup_values flv,
1063: fnd_lookup_types flt
1064: WHERE
1065: flv.lookup_type = p_lookup_type
1066: AND flv.view_application_id = p_view_app_id
1102: l_sysdate DATE := G_SYSDATE;
1103:
1104: CURSOR lkup_csr IS
1105: SELECT meaning
1106: FROM fnd_lookup_values flv,
1107: fnd_lookup_types flt
1108: WHERE
1109: flv.lookup_type = p_lookup_type
1110: AND flv.view_application_id = p_view_app_id
1773:
1774: /* cursor csr_get_rule_meaning(c_rule_code varchar2) IS
1775: SELECT meaning
1776: FROM fnd_lookup_types flt,
1777: fnd_lookup_values flv
1778: WHERE flv.lookup_type = flt.lookup_type
1779: AND flv.security_group_id = flt.security_group_id
1780: AND flv.view_application_id = flt.view_application_id
1781: AND flv.LANGUAGE = USERENV('LANG')