DBA Data[Home] [Help]

APPS.PER_IN_ADD_LEG_HOOK dependencies on DUAL

Line 65: select decode(p_state,'JH','BR','CG','MP',p_state) into l_state from dual;

61: pay_in_utils.trace('**************************************************','********************');
62: END IF;
63:
64: l_postal_code :=substr(p_postal_code,1,2);
65: select decode(p_state,'JH','BR','CG','MP',p_state) into l_state from dual;
66:
67: FOR i IN 1..tab_pin_code.COUNT LOOP
68: --
69: IF g_debug THEN