1532: CURSOR cur_get_meaning(p_lookup_code VARCHAR2) IS
1533: SELECT
1534: meaning
1535: FROM
1536: hr_lookups
1537: WHERE
1538: lookup_type = 'PAY_CA_MAG_EXCEPTIONS' and
1539: lookup_code = p_lookup_code;
1540:
1537: WHERE
1538: lookup_type = 'PAY_CA_MAG_EXCEPTIONS' and
1539: lookup_code = p_lookup_code;
1540:
1541: l_meaning hr_lookups.meaning%TYPE;
1542: l_msg_code VARCHAR2(30);
1543: l_all_box_0 BOOLEAN;
1544: l_format_mask VARCHAR2(30);
1545: l_sequence_number NUMBER(9);