399: l_audit_attribute_tbl,
400: l_action_date_tbl,
401: l_active_flag_tbl,
402: l_reversed_action_set_line_tbl
403: FROM pa_action_set_line_aud
404: WHERE action_set_line_id = p_action_set_line_id
405: AND active_flag = 'Y';
406:
407:
581: l_audit_lines_exist VARCHAR2(1);
582:
583: CURSOR do_audit_lines_exist IS
584: SELECT 'X'
585: FROM pa_action_set_line_aud
586: WHERE action_set_line_id = p_action_set_line_id;
587:
588: BEGIN
589:
617:
618: BEGIN
619:
620: SELECT max(trunc(action_date)) INTO l_action_date
621: FROM pa_action_set_line_aud
622: WHERE action_set_line_id = p_action_set_line_id;
623:
624: RETURN l_action_date;
625: