613: FROM DUAL;
614:
615: CURSOR req_cur IS
616: SELECT request_id
617: FROM FND_CONC_REQ_SUMMARY_V
618: WHERE parent_request_id = l_request;
619:
620: CURSOR grp_cur IS
621: SELECT group_id
639: WHERE reason_name LIKE p_reason_code;
640:
641: CURSOR arg_cur IS
642: SELECT argument_text
643: FROM FND_CONC_REQ_SUMMARY_V
644: WHERE request_id = l_child_request;
645:
646: BEGIN
647:
2540: FROM DUAL;
2541:
2542: CURSOR req_cur IS
2543: SELECT request_id
2544: FROM FND_CONC_REQ_SUMMARY_V
2545: WHERE parent_request_id = l_request;
2546:
2547: CURSOR grp_cur IS
2548: SELECT group_id
2561: WHERE reason_name LIKE p_reason_name;
2562:
2563: CURSOR arg_cur IS
2564: SELECT argument_text
2565: FROM FND_CONC_REQ_SUMMARY_V
2566: WHERE request_id = l_child_request;
2567:
2568: BEGIN
2569: