2543: WHERE lpn_id IS NOT NULL
2544: AND eligible_flag = 'Y';
2545:
2546: -- K LPN CONV. rv
2547: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
2548: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
2549: e_return_excp EXCEPTION;
2550: -- K LPN CONV. rv
2551: --
2544: AND eligible_flag = 'Y';
2545:
2546: -- K LPN CONV. rv
2547: l_lpn_in_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_in_rec_type;
2548: l_lpn_out_sync_comm_rec WSH_GLBL_VAR_STRCT_GRP.lpn_sync_comm_out_rec_type;
2549: e_return_excp EXCEPTION;
2550: -- K LPN CONV. rv
2551: --
2552: l_debug_on BOOLEAN;